Macro to open macros

  • Thread starter Thread starter Stu
  • Start date Start date
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
 
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)
 
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!
 
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
 
Back
Top