Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The problem:
------------ So I have Excel 2000 still. Some day I will upgrade. Windows XP SP2. I have three custom buttons on my custom toolbar. They are supposed to call three macros in Personal.xls. Well, each button should call one macro, but you know what I mean. When I click on any of the custom buttons, I get the message: "A document with the name PERSONAL.XLS is already open. You cannot open two documents with the same name". And so on. I *know* this, I don't want Excel to try to open Personal.Xls AGAIN, it's ALREADY open, you silly program, just use the macro out of the ALREADY OPEN copy of Personal.xls. If I start Excel and I'm looking at the empty Book1, I can go to Tools/Macros/Macro and run any of my three macros. All the macros do is some simple formatting. What I have done: ----------------- I right-click on the toolbar, choose Customize, then right-click on any of the buttons, and select Assign Macro. What I see in the Macro Name box is 'C:\Documents and Settings\David Walker\Application Data\Microsoft\Excel \XLSTART\PERSONAL.XLS'!Module1.FNumber2 Now, this is strange, because there's not a folder in Documents and Settings CALLED "David Walker", but there IS one called "David.DAVID-C". I have tried assigning the button to: 'C:\Documents and Settings\David.DAVID-C\Application Data\Microsoft \Excel\XLSTART\PERSONAL.XLS'!Module1.FNumber2 but when I look again, it's set to 'C:\Documents and Settings\David Walker\Application Data\Microsoft\Excel \XLSTART\PERSONAL.XLS'!Module1.FNumber2 I don't know where Excel gets off thinking my local stuff is in David Walker instead of in David.DAVID-C. When I'm looking at the Assign Macro window, the three macros are listed below as PERSONAL.XLS!Fdate and so on. I have tried assigning the custom button to just PERSONAL.XLS!FDate, by picking it from the box, but that still gives me the message that Excel can't open another macro with the same name. Plea for help: -------------- Does anyone have any suggestions how to get out of this mess? I have searched Google and there are only a few hits on that error message, none of which are very helpful. I have the same buttons working just fine in my setup at work, but they don't work in my setup at home. Thanks! David Walker |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2003 - 2007 custom macro and custom button restore. | Excel Discussion (Misc queries) | |||
How can I call IE browser (Back button) through Excel macro? | Excel Discussion (Misc queries) | |||
Custom button on custom toolbar wants to re-load "Personal.xls" | Excel Programming | |||
Call Userfor and click button with macro | Excel Programming | |||
Button won't call macro | Excel Programming |