Limit Excel Macro to run from Hot Key sequence only

[olympus]

I have a workbook in which all of the macros are password protected by the following line of code:

If Sheet1.TextBox1.Text <> "passsword" Then Exit Sub

I would like to be able to run a macro that is still password protected using the above code with a hot key/short cut key even if the password is not correct. I want to prevent all but the people that know the proper hot key sequence from running the macro. I would like this hot key to bypass the above line that requires the proper password in textbox1. Thanks!

 

[SkipVought]

olympus,

Make the Macro a Function with an argument.

The Hot Key macro calls the Macro Function.

You can call the Macro Function.

I specify a function so that it will not appear in the Macros Menu.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[olympus]

Skip, How do you specify a function so that it will not appear in the Macros Menu? Thanks.
John

 

[PHV]

How do you specify a function so that it will not appear in the Macros Menu?
Public Function yourFunctionName(Optional dumyArg As String = "some value") As yourFunctionReturnType

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244