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"