Hello all,

i have a program that runs in MS Excel. i do not want any one to see the MS
Visual Basic Editor option. i have already disabled Toools->Macros, but
AltF11 is a shortcut that i would like to disable. any help would be great.

Thanks, Josh

Why don't you just secure the code with a password.
In VBE Tool>Options>Properties>Protection then Lock code for viewing.

"Josh C" wrote:

> Hello all,
>
> i have a program that runs in MS Excel. i do not want any one to see the MS
> Visual Basic Editor option. i have already disabled Toools->Macros, but
> AltF11 is a shortcut that i would like to disable. any help would be great.
>
> Thanks, Josh

Sub noshow()
Application.OnKey "%{F11}", ""
End Sub
--
Gary''s Student - gsnu200723

Personally, I dislike the idea of a specific WB changing the user's
environment to suit its own needs.
As you have disabled Tools->Macros, the user can now not see ANY macros, not
only yours. Why should this be a good idea, as the user may be working with
several Excel files at the same time, not only yours.
As advised in the other post, use VBE protection and possibly "Option
Private Module"
Alternatively look into add-ins and COM addins.

NickHK

"Josh C" <(E-Mail Removed)> wrote in message
news:F547F489-5138-4687-A389-(E-Mail Removed)...
> Hello all,
>
> i have a program that runs in MS Excel. i do not want any one to see the
MS
> Visual Basic Editor option. i have already disabled Toools->Macros, but
> AltF11 is a shortcut that i would like to disable. any help would be
great.
>
> Thanks, Josh