Todd Bardoni
Well-known Member
- Joined
- Aug 29, 2002
- Messages
- 3,042
How do I disable Help in Excel. I'm creating an Excel Test and want to disable Help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Disable Help in Excel
- Thread starter Todd Bardoni
- Start date
Excel Facts
What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
Maybe these will help?
Simulating Disabling a Built-in Menu Command
You can't actually disable the built in menus, but you can make them THINK they are (on second thought, maybe this should go in the pranks thread
)
Disable all keys on the keyboard
Maybe you could have this run on workbook open, and just set it up so they enter all of their answers by mouse?
Just some ideas I found while searching for "disable help." Some days, the knowledge base is great
Simulating Disabling a Built-in Menu Command
You can't actually disable the built in menus, but you can make them THINK they are (on second thought, maybe this should go in the pranks thread
)Disable all keys on the keyboard
Maybe you could have this run on workbook open, and just set it up so they enter all of their answers by mouse?
Just some ideas I found while searching for "disable help." Some days, the knowledge base is great
Upvote
0
Todd Bardoni
Well-known Member
- Joined
- Aug 29, 2002
- Messages
- 3,042
Thanks, Von Pookie.
I already tried searching the board using "Disable Help" but all I got was a blank screen and then I tried it again and got an error message (the error came from the board). So, I figured the Search was not working today and decided to ask.
But thanks for the tip anyway! :D
Also, thanks for your help.
I already tried searching the board using "Disable Help" but all I got was a blank screen and then I tried it again and got an error message (the error came from the board). So, I figured the Search was not working today and decided to ask.
But thanks for the tip anyway! :D
Also, thanks for your help.
Upvote
0
Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
I got an error message here as well, but I did my search on the knowledge base first. Basically since I know the board's search function is still acting loopy
Upvote
0
Tom Urtis
MrExcel MVP
- Joined
- Feb 10, 2002
- Messages
- 11,305
Why not just disable the F1 key in a Workbook_Open or Aut
pen event, with the code line
Application.OnKey "{F1}", ""
and restore it at Close with
Application.OnKey "{F1}"
and regarding the Help menu item, try something like this, also at open and close as you prefer, or in the worksheet module depending on what you're trying to control:
On Error Resume Next
CommandBars("Worksheet Menu Bar").Controls("Help").Enabled = True 'False
pen event, with the code lineApplication.OnKey "{F1}", ""
and restore it at Close with
Application.OnKey "{F1}"
and regarding the Help menu item, try something like this, also at open and close as you prefer, or in the worksheet module depending on what you're trying to control:
On Error Resume Next
CommandBars("Worksheet Menu Bar").Controls("Help").Enabled = True 'False
Upvote
0
