View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default Calling a Sub from Another Sheet

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" wrote in message
...
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