I'm confused about Sub, Public Sub and Private Sub.
I've got a macro that protects certain sheet, hides certain sheets and protects the workbook. I also have another that that unhides and unprotects them all. They can be launched by keying Cntrl+j and Cntrl+Shft_J, respectively. Right now they code resides in Module 5 and thus far work perfectly.
But both are not Private Subs so they can be seen by a user in the macro box. If I make them Private they won't run. Is there a way to make these macros executable and NOT be seen in the macro box?
I've got a macro that protects certain sheet, hides certain sheets and protects the workbook. I also have another that that unhides and unprotects them all. They can be launched by keying Cntrl+j and Cntrl+Shft_J, respectively. Right now they code resides in Module 5 and thus far work perfectly.
But both are not Private Subs so they can be seen by a user in the macro box. If I make them Private they won't run. Is there a way to make these macros executable and NOT be seen in the macro box?