Personal Macro Workbook In The Startup Folder Must Stay Open For Recording

E1154478

New Member
Joined
May 23, 2013
Messages
8
Hi, I have Windows 7 and office 2007. Out of the blue, when trying to save a macro on personal workwook, Excel gives me the following message: personal workbook must stay open for recording a Marco on personal workbook. I've read previous thread, and tried the proposed solution
Click the Excel Options button.
In the categories pane, click Add-ins.
Disabled Items, and then click Go.
Select the disabled add-in and click Enable..

I enabled the Personal workbook but still the problem remain.
My personal workbook is in the right path:
C:\Users\ALBERTO\AppData\Roaming\Microsoft\Excel\XLSTART
And is called PERSONAL.XLSB
Does this file have to have a some specific settings? Shall I try to delete it and re-crerate it?I've tried everything but I’m stumped. Thanks
Alberto
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
What is the code you are trying to save in personal workbook?
Why are you trying to save it there instead of in the current workbook?
 
Upvote 0
Thanks for your answer. Because like that I can run the macro from each file Excel I want, not only from a specifica one
 
Upvote 0

Forum statistics

Threads
1,216,484
Messages
6,130,936
Members
449,608
Latest member
jacobmudombe

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