Reference must be to a macro sheet?

R

Robert Crandal

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!
 
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!

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

Top