Excel file with Macros that opened recently, now when prompted to and enabled macros, data and worksheets do not appear

Question

I have an excel file that prompts me to enable macros to bring up worksheets and data and be able to work in the file. Every time (on my mac) I would get the prompt to enable macros I would allow and the data would appear, up until recently. Now when I enable macros through the prompt that appears (attached) I get no data and the worksheets that used to appear do not show up either (they have the data I was editing and working on). Instead this is all I see (also attached). Any thoughts on what could be causing this to now not pull up any of the worksheets I have been working on?

Answer 1

Hi needexcelhelp3636,

Thanks for sharing updates with us. However I appreciate your effort and your precious time doing those. As you mentioned, "other macros files work on this computer, and I even have a secondary PC so I emailed myself the file in question, same thing, it is the only one that has this macros issue. Other files with macros work, just not this one," If it is convenient for you, could you please send the one of macro Excel file to me so that I can take a look from my side and test from my side to check I can reproduce issue or not.?

If there is confidential information, then you can send it to me in Private Message

Best Regards

Waqas Muhammad

Answer 2

Hi again,

Where is the file saved (Documents folder, OneDrive, SharePoint, somewhere else?)

What file format is the workbok (.xls .xlsx .slxb, something else?)

Answer 3

It is saved to a folder on my desktop on my mac.

The file is a .xlsm

Thanks,

Answer 4

Hi again,

I think you have very thoroughly removed the possibility of a faulty install.

How good are you with VBA? It appears that the macro has a coding error of some sort.

Answer 5

Sorry for the late reply, I know how to navigate to the VBA menu but after that my skills are limited :(