Personal Workbook Macros: unable to run, view, edit

Zenaida

New Member
Joined
May 23, 2017
Messages
6
Office Version
  1. 365
Platform
  1. Windows
I am unable to run my personal macros and also cannot view or edit them in visual basic editor; even though I can see them in the Project window. Also, the macros do not show up when I'm in Excel and click on View Macros. The personal workbook macros ran fine earlier this morning but stopped working after I closed and re-opened Excel.

I can run macros stored in other workbooks.
The location of my personal workbook is listed as a trusted location.
My personal workbook opens and loads with no issues.
Nothing shows up in the Disabled Items list.
With a macro selected in visual basic editor, I click on View Code and nothing happens.
I restarted my computer and have closed and re-opened Excel.


Not sure what else to try, other than creating a new personal workbook and starting over. Do different sessions of Excel have anything to do with this?

I appreciate your time and any assistance you can provide.

Excel 2016
Windows 10
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,223,909
Messages
6,175,310
Members
452,634
Latest member
cpostell

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