Go into the VBIDE (Alt-F11), select the module and change them.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ace70" wrote in message
oups.com...
Hi

Can someone please tell me how I can see/edit the VB code for all the
macros in my Excel worksheet that I had made Private by adding
"Private" to the start of the sub? As they do not appear in the emacro
list anymore, I can't select and edit them.

So basically, how do I "unPrivate" the macros back to their normal
visible state??

Cheers

Ace70