Reference must be to a macro sheet?

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

 

[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