Personal macro workbook

metsmaniac

Board Regular
Joined
Jan 29, 2010
Messages
57
Office Version
  1. 365
Platform
  1. Windows
I'm using a new laptop. I have many macros stored on my old PC in my Personal.xlsb file in my XLSTART folder.

I copied that file into the XLSTART file on my new laptop. When I click a macro icon, I get a message reading "Sorry, Excel can't open two workbooks with the same name at the same time."

There is no 2nd Personal.xlsb file. I click View>Unhide, and only one Personal.xlsb file is shown.

Any suggestions? Thanks.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
I'll give a guess: from your menu File / Options / select Advanced / in the General section / check if the box labeled "At startup, open all files in" is compiled. If so, maybe Personal.xlsb is launched by this the first time and then it's attempting to open a second time when you click a macro icon.
 
Upvote 0
I'll give a guess: from your menu File / Options / select Advanced / in the General section / check if the box labeled "At startup, open all files in" is compiled. If so, maybe Personal.xlsb is launched by this the first time and then it's attempting to open a second time when you click a macro icon.
Thanks. I don't have a box to check:
1648672105663.png
 

Attachments

  • 1648672078911.png
    1648672078911.png
    20.2 KB · Views: 4
Upvote 0

Forum statistics

Threads
1,214,648
Messages
6,120,726
Members
448,987
Latest member
marion_davis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top