I have multiple sheets all running code. However, there are times when I
would rather call a sub from another worksheet instead of duplicating the
code.

I used Call SubName to call it from the active sheet. What is the syntax for
calling it from say, Sheet1(Surface) instead of the current Sheet13(Intro)

Also, is there any way to organize the "Sheet1", "Sheet2", etc? Under
Microsoft Excel Objects, the actual order of the sheets is so out of order.
The "SheetX" name seems to be given when the sheets are created. Can this be
changed to better sort them?

Thanks

Hi Baconcow,

Try moving these subs to a standard module:

In the VBE,

Menu | Insert | Module.

A worksheet modul should normally only be
used for worksheet event code.



---
Regards.
Norman
"baconcow" <(E-Mail Removed)> wrote in message
news:1CF13F14-8ED4-4EF1-8972-(E-Mail Removed)...
>I have multiple sheets all running code. However, there are times when I
> would rather call a sub from another worksheet instead of duplicating the
> code.
>
> I used Call SubName to call it from the active sheet. What is the syntax
> for
> calling it from say, Sheet1(Surface) instead of the current Sheet13(Intro)
>
> Also, is there any way to organize the "Sheet1", "Sheet2", etc? Under
> Microsoft Excel Objects, the actual order of the sheets is so out of
> order.
> The "SheetX" name seems to be given when the sheets are created. Can this
> be
> changed to better sort them?
>
> Thanks

How do I call a sub that is on the standard module from the active worksheet?

"Norman Jones" wrote:

> Hi Baconcow,
>
> Try moving these subs to a standard module:
>
> In the VBE,
>
> Menu | Insert | Module.
>
> A worksheet modul should normally only be
> used for worksheet event code.
>
>
>
> ---
> Regards.
> Norman
> "baconcow" <(E-Mail Removed)> wrote in message
> news:1CF13F14-8ED4-4EF1-8972-(E-Mail Removed)...
> >I have multiple sheets all running code. However, there are times when I
> > would rather call a sub from another worksheet instead of duplicating the
> > code.
> >
> > I used Call SubName to call it from the active sheet. What is the syntax
> > for
> > calling it from say, Sheet1(Surface) instead of the current Sheet13(Intro)
> >
> > Also, is there any way to organize the "Sheet1", "Sheet2", etc? Under
> > Microsoft Excel Objects, the actual order of the sheets is so out of
> > order.
> > The "SheetX" name seems to be given when the sheets are created. Can this
> > be
> > changed to better sort them?
> >
> > Thanks
>
>

Hi Baconcow,

============
How do I call a sub that is on the standard module from the active
worksheet?
============

If you refer to calling a sub in a standard module
from worksheet event code, try:

Call myMacro

In fact, the same would apply to non event code
but, as indicated previously, a worksheet module
should normally only house worksheet event code



---
Regards.
Norman


"baconcow" <(E-Mail Removed)> wrote in message
news:7CB51136-070D-4FEA-A13C-(E-Mail Removed)...
> How do I call a sub that is on the standard module from the active
> worksheet?
>
> "Norman Jones" wrote:
>
>> Hi Baconcow,
>>
>> Try moving these subs to a standard module:
>>
>> In the VBE,
>>
>> Menu | Insert | Module.
>>
>> A worksheet modul should normally only be
>> used for worksheet event code.
>>
>>
>>
>> ---
>> Regards.
>> Norman