LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default Problem w/custom Macro Buttons on move to Laptop

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
URGENT Mac/PC macro compatibility problem marika1981 Excel Discussion (Misc queries) 7 January 8th 05 12:43 AM
Macro - - Automation Jac Excel Discussion (Misc queries) 8 December 27th 04 02:42 PM
macro problem Kevin Excel Discussion (Misc queries) 1 December 14th 04 10:47 PM
Macro Problem Kevin Excel Discussion (Misc queries) 1 December 9th 04 06:55 PM
Import chart to Power Point and Macro problem Woody13 Excel Discussion (Misc queries) 1 December 8th 04 05:47 PM


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"