Wheres My Macros Gone?

Dazzawm

Well-known Member
Joined
Jan 24, 2011
Messages
3,786
Office Version
  1. 365
Platform
  1. Windows
All of a sudden my macros in my PWB have dissappeared when I open an excel file. Though when I look at my Personal file in startup they are there.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
When I open a file on my desktop and go to view macros it is empty. When I go to C:\Users\Daz\AppData\Roaming\Microsoft\Excel\XLSTART and open the 'PERSONAL' file they are all in there fine.
 
Upvote 0
If there are buttons that still do certain procedures, the macroes are there. but if the procedures are no loger work so the macroes are gone


saved Xlsx or Xlsm????
 
Upvote 0
Did you receive a message indicating that there was trouble with an addin? It sounds to me that Excel ran into an issue and disabled access to it.
 
Upvote 0
If you click on the Office button, Excel Options, Addins, does your Personal Macro worbook appear in the list of disabled addins?
 
Upvote 0

Forum statistics

Threads
1,224,567
Messages
6,179,571
Members
452,927
Latest member
whitfieldcraig

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