Personal Macro Workbook Error

Finalfight40

Active Member
Joined
Apr 24, 2018
Messages
273
Office Version
  1. 365
Platform
  1. Windows
Hi

I am trying to put a macro on my work colleague's MAC.

We are running Excel 2016 but when I try to record a macro, I get the following error:

Personal Macro Workbook in the startup folder must stay open for recording.

Any ideas on how to solve this?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Perhaps your Personal Macro workbook has been disabled?
 
Upvote 0
I don't have a Mac here for testing, but in Windows you'd go to manage Addins and check the Disabled items list.
 
Upvote 0
I don't have a Mac here for testing, but in Windows you'd go to manage Addins and check the Disabled items list.

if its the bit that says Excel Add-ins, there are 2 there "Analysis Toolpak" and "Solver Add In" both of which are unticked.

I can't see a personal macro section here so maybe I'm in the wrong place.
 
Upvote 0
In Windows, it's under Options, I can't recall where it is (or if it exists) in the Mac version, but will check later if someone doesn't jump in in the meantime.
 
Upvote 0
Hi Rory

Just to let you know, i have found the problem with this now.

I believe someone had deleted the personal macro where it would be saved on start up on excel.

Just restored from the trash bin and it happens to work now.
 
Upvote 0
Thanks for letting me know. I confess I didn't have time to look into it last night.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

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