Prevent sheet add or delete
 

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

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