View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Prevent sheet add or delete

Glen,

By protecting the workbook.

Jim Cone
San Francisco, USA


"Glen Mettler" wrote in message
...
I have 2 gourps of users for my app - Administrators and Users. I need to
allow the Administrators to add/delete worksheets but I need to prevent the
User from adding or deleting a worksheet. I know how to use the IF
statements but how do I prevent add/delete of a worksheet?
TIA
Glen