Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In Excel 2000 on my WinXP Pro computer I had custom macro buttons that when
clicked executed the VBA code in my personal.xls file. The excel.xlb was located in c:\Documents and Setting\comp1\Application Data\Excel and the personal.xls file was located in "c:\Documents and Setting\comp1\Application Data\Excel\Xlstart". On my new laptop with Win XP Home I reinstalled Excel 2000 and put the excel.xlb file in c:\Documents and Setting\Laptop\Application Data\Excel and put the personnal.xls file into c:\Documents and Setting\Laptop\Application Data\Excel\Xlstart On the laptop when I bring Excel up the custom macro buttons are there and the personal.xls file is loaded ( I can see it in the Visual Basic Editor). However when I click on a custom macro button I get the following error: "A document with the name personal.xls is already open. You cannot open two documents with the same name even if the documents are in different folders." I did a search on the whole disk and there is only one file named personal.xls and it is located as above. If I click on Tools-Customize-right click the macro icon-assign Macro. The Assign Macro Window appears with the macro name c:\Documents and Setting\comp1\Application Data\Excel\Xlstart\Personal.xls!mymacro If I reassign the custom button to that same macro that shows up in the window list below the Macro Name which shows the name Personal.XLS!mymacro, than that custom macro button works fine after I close and reopen Excel while the other custom buttons still won't work. Since I have about 20 custom buttons assigned to 20 different VBA macros it would be cumbersome to reassign each button. Is there an easier way to redirect all the custom macro buttons to Personal.XLS!? Thanks for any help. Dennis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
URGENT Mac/PC macro compatibility problem | Excel Discussion (Misc queries) | |||
Macro - - Automation | Excel Discussion (Misc queries) | |||
macro problem | Excel Discussion (Misc queries) | |||
Macro Problem | Excel Discussion (Misc queries) | |||
Import chart to Power Point and Macro problem | Excel Discussion (Misc queries) |