Im having trouble connecting the button in one worksheet (which I have aptly named home page) to a macro in the next sheet. Im using excel 2003 can anyone help?![]()
Im having trouble connecting the button in one worksheet (which I have aptly named home page) to a macro in the next sheet. Im using excel 2003 can anyone help?![]()
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.
Last edited by BuckoAk; 09-01-2012 at 06:55 PM. Reason: updated line with additional comment
Let me give it a go, sounds like it should work.![]()
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.
Give Credit When Credit Is Due - Click On the Star
Be Sure To Mark Your Post [Solved] When You Get Your Answer
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!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks