Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal Macro
Excel 2000. I created an update Macro and now whenever I open any
Excel file a personal.xls file opens as well as the file selected. Clearly I am not using a right option when saving. Many of my excel files are using reused, many every month. I copy last months file to next months folder, rename the file and run the update macro and then amend other data as necessary. How should the particular update macro be stored? What strategy should I employ for saving each update macro as they vary from one macro to the next? TIA -- ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal Macro
My philosophy is if the macro is generic enough that I may want to use in any
and all workbooks, it goes into my personal.xl* file. If it's for a single specific workbook, then I put it in that workbook. If it's for a specific type of workbook -- not all, but more than one, then I create an addin that I open when I'm working on that type of workbook. I add an item to the worksheet menubar that allows me to execute my personal.xl* (I use a .xla, not .xls) that's based on John Walkenbach's code: For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm For the single workbook or multiple workbooks, I usually create a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) ======= ps. If you want to use personal.xls, I think that most people would want that workbook hidden. Open excel close all the other workbooks except for personal.xls then Window|Hide Then close excel. You'll be prompted to see if you want to save your changes to personal.xls--making it hidden. Answer yes and the next time you open excel, personal.xls will open in a hidden state. Gerry Cornell wrote: Excel 2000. I created an update Macro and now whenever I open any Excel file a personal.xls file opens as well as the file selected. Clearly I am not using a right option when saving. Many of my excel files are using reused, many every month. I copy last months file to next months folder, rename the file and run the update macro and then amend other data as necessary. How should the particular update macro be stored? What strategy should I employ for saving each update macro as they vary from one macro to the next? TIA -- ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal Macro
This may be your Personal.xls file which contains your local modules. Check
to see if Window/Unhide is grayed out. If it is then it is your personal.xls file. In this case, with the personal.xls file as the activewindow, just on Windows / Hide, hide personal.xls. Now personal.xls will open hidden. Be sure and choose save changes to your personal.xls workbook. Regards, Alan "Gerry Cornell" wrote: Excel 2000. I created an update Macro and now whenever I open any Excel file a personal.xls file opens as well as the file selected. Clearly I am not using a right option when saving. Many of my excel files are using reused, many every month. I copy last months file to next months folder, rename the file and run the update macro and then amend other data as necessary. How should the particular update macro be stored? What strategy should I employ for saving each update macro as they vary from one macro to the next? TIA -- ~~~~ Gerry ~~~~~~~~ Enquire, plan and execute. Stourport, England ~~~~~~~~~~~~~~~~~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal Macro | Excel Discussion (Misc queries) | |||
Macro runs in source , but not when in Personal Macro Workbook | Excel Programming | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
personal.htm & personal.xls in Macro | Excel Programming |