Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ian;
Did you Google on "Disable F1 Key". I know there is some stuff to find about that topic and your question might probably be answered the same way. Actually, here it is. a.. Unhide your personal.xls file a.. Tools-Macros-Visual Basic Editor a.. Choose the "ThisWorkbook" file icon in the upper left hand box a.. Add this VB code: Private Sub Workbook_Open() Application.OnKey "{F1}", "" End Sub a.. Save the file, and close. Result: No more accidental MS help windows! I did not test it, but I assume that it might help with F11 as well. -- Regards; Mark Rosenkrantz -- Spreadsheet Solutions Uithoorn Netherlands (the country were they live some 18 feet beyond sea level) E: W: www.spreadsheetsolutions.nl -- "Ian" wrote in message ... All, Searched for a while, but haven't found an answer to this one yet. I have a workbook that I do not want the users to add worksheets or charts to. In particular by a stray keystroke of F11 (like when I forget to hold alt and hit it myself :-/ ) Is there a way to disable adding sheets / charts? TIA, Ian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
code to prevent users from adding new worksheets | Excel Worksheet Functions | |||
Adding new data to tables and charts in excel sheets from 97/2003 | Excel Worksheet Functions | |||
Prevent users from adding rows in Excel 2000 | Excel Discussion (Misc queries) | |||
prevent users from overwriting other users data | Excel Worksheet Functions | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |