MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

editing a macro

  Asked By: Jose    Date: Nov 23    Category: MS Office    Views: 1328

Did I ever do something STUPID ...
I was editing a macro, and made it Private: Private Sub Solve()
Now I can't even FIND it because it's private.
How do I get it back?



6 Answers Found

Answer #1    Answered By: Abaigael Cohen     Answered On: Nov 23

Simply make it PUBLIC.............

Answer #2    Answered By: Abella Martin     Answered On: Nov 23

The problem is that I can't FIND it to change it.
It's not in the list of macros now.

Answer #3    Answered By: Michelle Clark     Answered On: Nov 23

You will need to activate the VB Editor.

Tools -> macro  -> Visual Basic Editor


Alt + F11

will open up the VB Editor.

Chose the file that the macro is in and the Module that the macro is

Then U can change it by removing "Private"

Answer #4    Answered By: Tina Simmons     Answered On: Nov 23

Maybe you already tried but I think it's worth mentioning:
did you try "Edit --- Find --- and check "current project"
This is assuming you know in which project the macro  is located.

Answer #5    Answered By: Zoheth Mizrachi     Answered On: Nov 23

If u want that your macro  will appear in Macro list then you have to define your
macro as SUB/PUBLIC only insted of PRIVATE.

Answer #6    Answered By: Blasa Fischer     Answered On: Nov 23

You didn't say, but I'm assuming you are trying to edit it from the
Tools/Macro/Macros option in Excel (Alt-F8)?

But you made  the macro  private so now it's gone from that pop-up window.

All that this window does (when you select edit) is take you to the Visual Basic
Environment (VBE) to edit your macro, and open the appropriate module so you can
start editing.

Just do Alt-F11 (or Tools/Macro/Visual Basic Editor) and you'll see your
project. Expand it (click the little plus sign), then expand Modules, then
double click Module1. Your macro should be sitting in there.

Didn't find what you were looking for? Find more on editing a macro Or get search suggestion and latest updates.