Alt + F8 - Security issue

[gmazza76]

Good Afternoon All,

I have a lot of VB in a spreadsheet that is locked to stop people adding / removing the programming.

As i am using Hide / Reveal on some sheet is can be run using ALT + F8 if people know how to do it.

Is there anyway i can stop the info showing in ALT + F8 or a way of locking it being used?

Many Thanks

 

[sous2817]

you can change your macros (or modules) to Private and it won't show up in that list, but they'll still be able to explicitly call the macro if they know the macro's full name.

For instance copy both of these in to a new module:

Sub foo()
MsgBox "This is in the alt+F8 list"
End Sub

Private Sub foo2()
MsgBox "This isn't the alt+F8 list"
End Sub

and press alt+F8

 

[gmazza76]

Cheers

Thats spot on