How can I get back in to macros that I made private in the past so that I can alter their code?

[Glühbirne]

Hello Everyone,

I recently started working in a workbook that I had made quite a few months ago. I had made my macros private because I didn't want users to be able to run them in any way except for through buttons that I had inserted. Now, I want to get back into my macros and work on the code some more, but I don't know how to get in to them to even see the code. I try right clicking on the worksheets and selecting "View Code", in Visual Basic but that doesn't do anything. I know that the macros are still there, because I had attached them to buttons, and those buttons still work and run them. Am I destined to never be able to get into my macros again, or is there a way to find them? Thanks in advance for your help.

 

[Andrew Poulsom]

Press Alt+F11 to open the Visual Basic Editor. Look at the code in all the modules in your workbook.

 

[Smitty]

Welcome to the Board!

ALT+F11 will open the VBE (Visual Basic Editor), where you can browse to your code. If it's not event code then it's most likely going to be stored in Modules.. Just look through each object in the Project Explorer until you find your code.

HTH,

 

[Glühbirne]

I don't see any modules. I'm looking in the "Project Explorer." Is this the correct place to look? All I see are all of my worksheets. Pardon my ignorance.

 

[Andrew Poulsom]

Are the macros in your PERSONAL.XLS?

What sort of buttons do you have?

 

[Glühbirne]

Are the macros in your PERSONAL.XLS?

What sort of buttons do you have?

I'm not sure. How can I check, or where might I find my PERSONAL.XLS?

I just have grey buttons that I got from going to the Developer Tap and clicking "Insert" in the Controls group and then selecting button from the "Form Controls" and dragging it to the place I wanted it. If I remember correctly, I attached the button to the macro before making the macro private, then made the macro private after the fact. The macros all start with "mac_" but other than that I can't even remember the exact names.

 

[Andrew Poulsom]

If you right click the button and choose Assign Macro you should be able to click Edit.

 

[Glühbirne]

Okay, when I do that I do get the macro name, but the only options are "New" and "Record." There is no option to "Edit."

At least I can get the exact names now though, which is a start, I guess.

Any other ideas? Could the whole module be hidden maybe? I certainly have learned my lesson not to hide things when I don't really know what I'm doing.

 

[Andrew Poulsom]

What is the name of the macro? If you click the button does the macro run? Maybe the workbook that contains it isn't open, but it will open if you click the button.

 

[Glühbirne]

What is the name of the macro? If you click the button does the macro run? Maybe the workbook that contains it isn't open, but it will open if you click the button.

"The macro may not be available in this workbook or all macros may be disabled." All macros are enabled, so it must be the former.