Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable ALT KEY
Is it possible to disable the Ctrl or Alt key using vba code to protect
against someone inadvertantly adding a sheet to a workbook, Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable ALT KEY
Have you considered protecting the workbook? You can do it manually using
Tools--Protection--Protect Workbook and assigning a password, or use the following code: ActiveWorkbook.Protect Password:="PasswordHere", Structu=True, Windows:=False -- _______________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Dunce in SC" wrote in message ... Is it possible to disable the Ctrl or Alt key using vba code to protect against someone inadvertantly adding a sheet to a workbook, Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable ALT KEY
Hi Robert:
I have tried but I have many macros accessing a couple of very hidden sheets (brings up errors with protected workbook) and I am just concerned that a user may inadvertantly hit the wrong key combinations and mess up the program. The Menu is custom and I think disabling those keys will best solve my problems if it is possible. Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable # | Excel Discussion (Misc queries) | |||
Disable MS Excel 12 | Setting up and Configuration of Excel | |||
How do I disable a SORT | Excel Discussion (Misc queries) | |||
Disable Alt+F11 | Excel Discussion (Misc queries) | |||
disable F1 | Excel Discussion (Misc queries) |