Re: Reference must be to a macro sheet?

G

GS

I made a few copies of Sheet1 by right-clicking the tab and
choosing "Move or Copy", followed by "Create a copy".

Next, I added one one Button control on each sheet.
When I try to assign an existing sub procedure to some
of the buttons I get the following error message:

"Reference must be to a macro sheet"

Does anybody know why this error message is
occurring and how to fix it?

Thanks!
Click to expand...

Assigned macros should be stored in a standard module, IMO.
Button_Click event code should be stored in the code window of the
sheet the button resides on.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to make macro work even a sheet is hidden. 3
Macro to copy a sheet and delete a macro button 8
Macro to Call A Subroutine on a Sheet Sometimes stops? 1
Assigning macro buttons to macro code in another file 2
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
A macro to parse a wordlist in Excel 1
Get Name of Sheet to use in Macro 11
How do I refer to a custom toolbar button? 3

Top