Macro that calls other macros in different sheets

**mlcfexcel** · 05-05-2007, 01:11 AM

Dear All,

I'm trying to create a macro that calls other macros in the same workbook but in differente sheets. I've made a code that is working but doesn't seems to be the best one (if you see the sheets names are all much alike).
The code is this:

Please Login or Register  to view this content.

Coul you try to help me on this one, please?

Regards

Manuel

**mudraker** · 05-05-2007, 02:43 AM

Try this macro

Please Login or Register  to view this content.

**jpod** · 05-05-2007, 04:44 AM

If this is a macro on sheet1:

Please Login or Register  to view this content.

Then you should be able to run this code in another sheet:

Please Login or Register  to view this content.

Is that what you'r looking for?

**jpod** · 05-05-2007, 04:50 AM

If you are trying to run one macro but have it apply to different sheets, you can declare a public sheet object and change it every time you run the macro.

Please Login or Register  to view this content.

**davesexcel** · 05-05-2007, 05:01 AM

Hi,
are you creating the same action in each sheet?

**mlcfexcel** · 05-05-2007, 07:44 AM

Thank you all for your help!

All tips were very useful.

Dave: The action in each sheet is similar but not the same, therefore I had to create a macro for each one. By the way, what sould I do If the macro is the same for each sheet?

Regards

Manuel

Macro that calls other macros in different sheets

LinkBack

Thread Tools

Rate This Thread

Display

Macro that calls other macros in different sheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions