[RESOLVED] Not allow users to delete a sheet

[pgag45]

I've been searching for a protection command that doesn't allow the user to delete/rename a sheet, but haven't found it exactly. I know I could just protect the sheet, but I want the user to be able to edit any info in it...

Also, I need to be able to delete/rename the sheet through the code (would I need to take this property away, delete/rename the sheet, then set the property again?)

So basically is there a really low level property of protection that doesn't allow the user to delete or rename sheets in the workbook (still allowing the programmer total control), but still able to edit any data within those sheets?

thanks

[Siddharth Rout]

I've been searching for a protection command that doesn't allow the user to delete/rename a sheet, but haven't found it exactly. I know I could just protect the sheet, but I want the user to be able to edit any info in it...

yes that is possible

Simply protect the workbook
tip: you can protect the structure of the workbook which will ensure that no one can delete the sheet.

Also, I need to be able to delete/rename the sheet through the code (would I need to take this property away, delete/rename the sheet, then set the property again?)

That again is possible.

use the .Protect and .Unprotect command to achieve what you want thru code. Give it a try. In case you get stuck, simply post a question here

Hope this helps...

[pgag45]

hrmm.. simple enough!

Thanks a lot sid

[Mitch_s_s]

would userinterface apply to the protection of the workbook, like is does with sheets?