Disable Alt F8 functionality

[Bozo]

Hi,

I have a file where I have password protected the VBA code. One of the macros within the file unprotects the sheets in the file which are all password protected.

However, if a user uses Alt F8 they can see and run the unprotect macro. I am looking for a solution to this issue but can only come up with renaming the macro to something obscure so no user will know what the macro does.

Is there a more sophisticated solution to this issue?

[6StringJazzer]

How do you invoke the existing macro normally? Is it invoked from a different module where it is written? If not, declare it as Private instead of Public, and it will not be visible in the list of macros when you hit Alt-F8.

[Bozo]

Brilliant!!! Many thanks, the perfect solution.