Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Worksheet Objects from PERSONAL.xls
I would like to run a few worksheet events (activate/deactivate, change) from
my PERSONAL.xls file. The only reason I want to do this is so I don't have to insert macros in these files that are stored on a shared network. I know how to run the macros from the file itself, but can I do it remotely from PERSONAL.xls? My basic purpose for this macro is to have a running total of stuff so I don't have to go back to a certain sheet that gives me this information. It's more of a convenience macro than anything else. Thanks in advance. -- I am running on Office 2003, unless otherwise stated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Worksheet Objects from PERSONAL.xls
There are application events that you can monitor from any workbook:
You can read more about application events at Chip Pearson's site: http://www.cpearson.com/excel/AppEvent.aspx Be aware that you're gonna see those events from every workbook. You may want to check to see if your code should continue (sheet name or workbook name or combination???). Orion Cochrane wrote: I would like to run a few worksheet events (activate/deactivate, change) from my PERSONAL.xls file. The only reason I want to do this is so I don't have to insert macros in these files that are stored on a shared network. I know how to run the macros from the file itself, but can I do it remotely from PERSONAL.xls? My basic purpose for this macro is to have a running total of stuff so I don't have to go back to a certain sheet that gives me this information. It's more of a convenience macro than anything else. Thanks in advance. -- I am running on Office 2003, unless otherwise stated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal Worksheet | Excel Discussion (Misc queries) | |||
How do I unhide the PERSONAL.XLS worksheet? | Excel Worksheet Functions | |||
PERSONAL worksheet problems | Excel Programming | |||
Assigning a macro to a worksheet (vs personal.xls) | Excel Programming |