Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Personal.xls error - "file Is already open"
I have verified that ther is only one version of Personal.xls anywhere on the
C: drive and that it is in the xlstart folder. The macros are assigned to a custom toolbar. I can run the macros from the menu just fine. But when I try to run from the tool bar buttons I get the message that the "file is already open". I'm not sure this is a Personal.xls problem or a toolbar problem. Hopefully someone will have some ideas of how to fix this. Thanks, Irene |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Personal.xls error - "file Is already open"
The icons on the toolbar are still assigned to your other personal.xls workbook.
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) Irene wrote: I have verified that ther is only one version of Personal.xls anywhere on the C: drive and that it is in the xlstart folder. The macros are assigned to a custom toolbar. I can run the macros from the menu just fine. But when I try to run from the tool bar buttons I get the message that the "file is already open". I'm not sure this is a Personal.xls problem or a toolbar problem. Hopefully someone will have some ideas of how to fix this. Thanks, Irene -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Personal.xls error - "file Is already open"
ps. That other personal.xls could have been the one you were using while you
were developing your macros. And I bet when you were happy, you copied that file to XLStart. Dave Peterson wrote: The icons on the toolbar are still assigned to your other personal.xls workbook. 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) Irene wrote: I have verified that ther is only one version of Personal.xls anywhere on the C: drive and that it is in the xlstart folder. The macros are assigned to a custom toolbar. I can run the macros from the menu just fine. But when I try to run from the tool bar buttons I get the message that the "file is already open". I'm not sure this is a Personal.xls problem or a toolbar problem. Hopefully someone will have some ideas of how to fix this. Thanks, Irene -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal.xls gone | Excel Discussion (Misc queries) | |||
Formula not being called from personal.xls | Excel Discussion (Misc queries) | |||
problem from Personal.xls | Setting up and Configuration of Excel | |||
Personal.xls | Excel Discussion (Misc queries) | |||
Personal.xls and Excel.xlb | Excel Discussion (Misc queries) |