View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default prevent users from adding sheets / charts


Protecting the workbook (structure) prevents the addition of sheets.
--
Jim Cone
Portland, Oregon USA



"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