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.