Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I stop Excel from reopening personal.xl when I run a macro?
I have a personal macro file containing several (over 20) macros. Each time
I run a macro, it tries to reopen the macro file. How do I keep Excel from trying to open the file every time I run a macro? This is a new problem. The personal macro file was started about 3 years ago and this problem started about 3 weeks ago. Thank you, D Wright |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I stop Excel from reopening personal.xl when I run a macro?
How are you driving the macro? If it is a button, worksheet function,
then the link is still made to ['Personal.xls']SomeMacro D Wright wrote: I have a personal macro file containing several (over 20) macros. Each time I run a macro, it tries to reopen the macro file. How do I keep Excel from trying to open the file every time I run a macro? This is a new problem. The personal macro file was started about 3 years ago and this problem started about 3 weeks ago. Thank you, D Wright |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I stop Excel from reopening personal.xl when I run a macro?
I'm guessing that you have a toolbar with icons or additional options added to
the worksheet menu bar that call your macros. These buttons/options are pointing at some other personal.xls file--not the one that's currently loaded in memory. (Maybe you changed the location of your personal.xls file????) Your life will become much simpler if you include code to create the toolbar when the workbook is opened and include code to destroy the toolbar when the workbook is closed. 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 Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) D Wright wrote: I have a personal macro file containing several (over 20) macros. Each time I run a macro, it tries to reopen the macro file. How do I keep Excel from trying to open the file every time I run a macro? This is a new problem. The personal macro file was started about 3 years ago and this problem started about 3 weeks ago. Thank you, D Wright -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Worksheet Functions | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Discussion (Misc queries) | |||
close workbook without closing excel and stop recursive function | Excel Discussion (Misc queries) | |||
Asked previously...can this not be done in excel | Excel Discussion (Misc queries) |