ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to protect from insert, delete, resequence worksheet in workbook (https://www.excelbanter.com/excel-programming/313837-how-protect-insert-delete-resequence-worksheet-workbook.html)

tango

how to protect from insert, delete, resequence worksheet in workbook
 
dear all,
how to protect the workbook or disable user from tampering the
worksheet? i do not want user to insert new worksheet, delete existing
worksheet, resequence the worksheet. how to write a simple script to
disable user to do all these.
thanks alot

Neil[_11_]

how to protect from insert, delete, resequence worksheet in workbook
 
tango,
Try
Tools|Protection|Protect Workbook
Neil
"tango" wrote in message
om...
dear all,
how to protect the workbook or disable user from tampering the
worksheet? i do not want user to insert new worksheet, delete existing
worksheet, resequence the worksheet. how to write a simple script to
disable user to do all these.
thanks alot





All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com