Share via

Excel Macros not Visible

Anonymous
2021-05-25T04:00:39+00:00

I have a workbook in which I consolidate data from various CSV files. There are a number of macros in this file including ones to add new sheets to the file, which is on a shortcut key Ctrl+****+N. This has been working perfectly for many years. This morning the shortcut key does absolutely nothing. If I go to the Excel developer tab and click on the Macros button, the list of macros is empty. However, if I open VBA I can run the macro from there and it still works perfectly.

I run Office Professional Plus 2019 and it ran an update yesterday. Does anyone know of a new setting introduced that may hide the macros in Excel itself. Note that macros are enabled on this workbook.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-05-25T04:50:36+00:00

    Hi Renier!

    I'm Jen, an independent advisor and a Microsoft user like you. I'd be happy to help you out with this issue.

    Try to open the Macro dialog and make sure the "All Open Workbooks" is selected from the Macros in listbox.

    I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

    Best Regards!

    Jen :)

    0 comments
  2. Anonymous
    2021-05-25T05:49:28+00:00

    Hi Jen,

    Thank you for taking the time to respond. However, that is not the problem as you can see below.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2021-05-26T02:44:17+00:00

    Hi Renier,

    Could you please try the suggestions in the following thread? Thanks.

    https://answers.microsoft.com/en-us/msoffice/fo...

    0 comments