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