Need to activate a subroutine in a sheet, from a module within the same project.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shawn - 29 Jul 2004 23:57 GMT

I know this must be very simple, but I've trieds lots of things and
had no luck. I have a sheet with a macro in {Sheet4(manual_check)} is
what it's called, and need to call a routine called Running, or click
a button on that sheet called RunIt. I have declared both as public
subs, so I don't believe that to be the problem. A few things I have
tried have included:
- Call Sheet4.Running
- Call ActiveWorkBook.Sheets("manual_check").Running
- WorkSheets("manual_check").Activate
RunIt_Click

and many more.

I'm going crazy. Help me out! Thanks...

Shawn

Reply to this Message

Leslie A Rhorer - 31 Jul 2004 20:12 GMT

Unless I am missing something, provided all the worksheets are loaded,
you should just be able to do

Call Running()

I call public subroutines from foreign projects all the time. You don't
have private variables defined in the target project but external to the
target module, do you?

> I know this must be very simple, but I've trieds lots of things and
> had no luck. I have a sheet with a macro in {Sheet4(manual_check)} is
[quoted text clipped - 12 lines]
>
> Shawn

Reply to this Message

VB Forum / General 2 / July 2004

Need to activate a subroutine in a sheet, from a module within the same project.