Macro to open macros

S

Stu

I need a macro to open multiple macros when it is ran. Any ideas ?(by
the way, Im not very experienced with macros as you might be able to
tell).

Thanks
 
B

Bob Phillips

Stu,

See reply in .programming.

If you want to hit multiple groups, do it all in one post, not multiple
posts. It just helps everybody.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
S

Stu

I have 9 sheets and 12 macros in each sheet, I have put the 12 macros
into one macro in the same sheet but I can't seem to run the macro from
another sheet if I add it to a sub or make a new sub for this. Help!
 
G

GB

Stu said:
I have 9 sheets and 12 macros in each sheet, I have put the 12 macros
into one macro in the same sheet but I can't seem to run the macro from
another sheet if I add it to a sub or make a new sub for this. Help!
Click to expand...

Try this:

Go the Visual Basic Editor. Click Insert Module, then stick all your
macros in there.

The thing is that if you have a macro called Test in the code attached to
sheet1, it actually has to be referenced by its full name Sheet1.Test - at
least that applies to any code outside the sheet 1 code. You can call it
from the other worksheet code by using its full name, ie Sheet1.Test.

On the other hand if you stick the macros in a general module, they can be
referenced from any of the sheets just by their ordinary names, ie Test in
the example above.

HTH (and is moderately clear!)

Geoff
 
Top