Click button in one worksheet to activate Macro in another

You can do 1 of 2 things.

If you macro your trying to call is Labeled with "Private" use = Book1!Sheet2.MyMacro , without the = sign

• Book1 is the Name of your Wookbook
• Sheet2 is the Worksheet name. See "Project Explorer" for sheet number i.e. Sheet2(Home Page)
• MyMacro is the name of your macro you are trying to call.

Or you can simply remove the Private from the sub then assign it to your button.

If your happy with your answer, be sure to mark you post as [Solved].
At the Top Right of your Post You can:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

You can also give credit by clicking on the Star at the bottom left of the supporting post.

Originally Posted by guvner5

Thanks for the help, only got to use it last night. Hopefully you will come to my rescue again in the not so distant future!

I'm glad it's working for you.
I'll be here.