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
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