Excel 97 - Prevent Renaming/Deleting Protected Worksheet
 

How can I prevent a user from renaming or deleting a
protected worksheet in my application?

Any solutions or suggestions would be appreciated.

Excel 97 - Prevent Renaming/Deleting Protected Worksheet
 

Protect workbook ought to do it

"Barbarr_ON" wrote in message
...
How can I prevent a user from renaming or deleting a
protected worksheet in my application?

Any solutions or suggestions would be appreciated.

Excel 97 - Prevent Renaming/Deleting Protected Worksheet
 

If you password protect the below option, that helps ever
further.


-----Original Message-----
Protect workbook ought to do it

"Barbarr_ON" wrote
in message
...
How can I prevent a user from renaming or deleting a
protected worksheet in my application?

Any solutions or suggestions would be appreciated.


.

Excel 97 - Prevent Renaming/Deleting Protected Worksheet
 

Tools=Protection=Protect Workbook, select at least Structure

--
Regards,
Tom Ogilvy


"Barbarr_ON" wrote in message
...
How can I prevent a user from renaming or deleting a
protected worksheet in my application?

Any solutions or suggestions would be appreciated.

Excel 97 - Prevent Renaming/Deleting Protected Worksheet
 

Yes, of course, workbook protection works and I've got
the VBA code worked out. What can I say but "brain fart"
or a "senior moment". Thanks for the help.

-----Original Message-----
How can I prevent a user from renaming or deleting a
protected worksheet in my application?

Any solutions or suggestions would be appreciated.
.