ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   protection workbook (https://www.excelbanter.com/excel-programming/313839-protection-workbook.html)

tango

protection workbook
 
how to put a script in workbook open

for tools-protection-protect workbook?

after protected, user cannot add/remove/resequence the worksheet in
the workbook but they still can edit on the existing sheets, right?

thanks

Neil[_11_]

protection workbook
 
tango
ActiveWorkbook.Protect Structu=True, Windows:=False
Neil
"tango" wrote in message
m...
how to put a script in workbook open

for tools-protection-protect workbook?

after protected, user cannot add/remove/resequence the worksheet in
the workbook but they still can edit on the existing sheets, right?

thanks





All times are GMT +1. The time now is 12:24 PM.

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