I was on your side.

--
Regards,
Tom Ogilvy

"Rob Bovey" wrote in message
...
"Tom Ogilvy" wrote in message
...
Just some added thoughts.

Rob's method could of course could be easily defeated through overt
action by the user to break the protection.

Jim's method (like any software based protection) could be inadvertently
defeated by setting security to high and the user would never know you
cared whether worksheets were added or not.

Yes, of course. Clearly, applying a strong file-open password to the
workbook and then not supplying the user with that password would be a
more robust method of preventing new worksheets from being added. ;-)

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm