I have a excel file with macros that I have been running for months.
The other day the macros all disappeared from the view macros button.
I can open up visual basic and they are there and will run from there.
How can I get them back to normal?
I had shortcuts for them.
What modules are they in? They have to be in standard modules to be visible from View Macros. If they are in worksheet modules you won't see them there.
They are in Module1, in folder Modules
Attachment 696492
Are you sure you had the right workbook selected in the View Macros In dropdown?
Rory
Yes, I have tried all the options.
Attachment 696494
Your attachments don't work. You need to click Go Advanced then Manage Attachments, and then upload the pictures that way. Or just describe what they show.
Just on the off chance, if there is a line that says Option Private Module at the top of the module, delete it.
My apologies.
Here are the pics.
Did you save your workbook as an add-in? If so, the macros won't appear in the dialog.
No, the macros were working proper for months, until a few days ago.
Can you post the workbook? It will save a lot of time.
Upon trimming down the workbook to upload on here. I noticed the macros re-appeared.
So I did some back tracking and I had all but one macro in Module1. I deleted the macro in Module2 and every re-appeared as it should.
Looks like I'm back in business.
Thank you for your time.
That solution doesn't make sense, but I'm glad you solved it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks