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

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

You will need to activate the VB Editor.

Tools -> macro  -> Visual Basic Editor

or

Alt + F11

will open up the VB Editor.

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

Then U can change it by removing "Private"

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.

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.

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.