Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button reference
I have a VBA macro (macro1) in "Master.xls" in which I created a button to
run the macro. The macro runs and does it's thing. When it is done I do a File Save-As "Test.XLS". I exit Excel and DO NOT save changes to "Master.xls" (I have made it read-only). I re-open "Master.xls" and click the button I created previously. For some reason the button now references "Test.xls!Macro1". I want this button to ALWAYS run the macro from "Master.xls". I have tried changing the marco reference to "Master.xls!macro1". I can not make this reference static for some reason. Can it be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button reference
Is the button on a command bar, or on a sheetin Master.xls?
Greg Franke wrote: I have a VBA macro (macro1) in "Master.xls" in which I created a button to run the macro. The macro runs and does it's thing. When it is done I do a File Save-As "Test.XLS". I exit Excel and DO NOT save changes to "Master.xls" (I have made it read-only). I re-open "Master.xls" and click the button I created previously. For some reason the button now references "Test.xls!Macro1". I want this button to ALWAYS run the macro from "Master.xls". I have tried changing the marco reference to "Master.xls!macro1". I can not make this reference static for some reason. Can it be done? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Button reference
Thanks for the response.
The button is on a command bar. Should I try to embed it in a worksheet? "OKROB" wrote in message ups.com... Is the button on a command bar, or on a sheetin Master.xls? Greg Franke wrote: I have a VBA macro (macro1) in "Master.xls" in which I created a button to run the macro. The macro runs and does it's thing. When it is done I do a File Save-As "Test.XLS". I exit Excel and DO NOT save changes to "Master.xls" (I have made it read-only). I re-open "Master.xls" and click the button I created previously. For some reason the button now references "Test.xls!Macro1". I want this button to ALWAYS run the macro from "Master.xls". I have tried changing the marco reference to "Master.xls!macro1". I can not make this reference static for some reason. Can it be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to reference MSNStockQuote button within a macro | Excel Worksheet Functions | |||
How to I reference in VB a button used to run an Excel macro | Excel Programming | |||
Macro Relative reference button greyed out. | Excel Programming | |||
Make macro-button sheet reference relative | Excel Programming | |||
relative reference button on end macro menu | Excel Programming |