Thread: is it possible to unable the user to add more sheets to a workboo
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jjk jjk is offline
external usenet poster
  
Posts: 42
Default is it possible to unable the user to add more sheets to a workboo
Using menu Goto
Tools - Protection - Protect Workbook
Make sure Structure is checked.

Programatically
ThisWorkbook.Protect Structu=True

Regards,
Jayant

Reply With QuoteReply With Quote