Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference must be to a macro sheet?
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference must be to a macro sheet?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
Make macro-button sheet reference relative | Excel Programming | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |