Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set a worksheet object on Open that doesn't die?
I am creating a "template" workbook. When done, it will have a
"splash" worksheet, a "tools" worksheet with buttons for different macros, and a "list" worksheet. A macro in the "MASTER" workbook pulls up this template and adds the "list" worksheet depending on the project, so the name of the "list" worksheet is never the same. All of the "tools" macros, though, need to work on this "list" worksheet. Is there code I can put in the Workbook_Open event that will set a reference or object to this "list" worksheet that can be referenced by the macros as long as the workbook is open? Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Programming | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel |