View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Spreadsheet Solutions[_3_] Spreadsheet Solutions[_3_] is offline
external usenet poster
 
Posts: 31
Default prevent users from adding sheets / charts

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