Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ThisWorkbook.Protect
Am I right in saying that the UserInterfaceOnly setting can only be applied
at Worksheet level, not Workbook level? So I have to unprotect the workbook at the start of each macro and then protect it again at the end? Seems a bit of an oversight, if so. -- Return email address is not as DEEP as it appears |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ThisWorkbook.Protect
I see UserInterfaceOnly in VBA's help for worksheets--not for workbooks.
But if you've protected the workbook's structure and want to add/delete/rename a sheet, then yep, you have to unprotect/do the work/reprotect. Did you really protect the workbook? I protect worksheets much more often than the workbook. Jack Sheet wrote: Am I right in saying that the UserInterfaceOnly setting can only be applied at Worksheet level, not Workbook level? So I have to unprotect the workbook at the start of each macro and then protect it again at the end? Seems a bit of an oversight, if so. -- Return email address is not as DEEP as it appears -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ThisWorkbook.Protect
Thanks Dave.
"Dave Peterson" wrote in message ... I see UserInterfaceOnly in VBA's help for worksheets--not for workbooks. But if you've protected the workbook's structure and want to add/delete/rename a sheet, then yep, you have to unprotect/do the work/reprotect. Did you really protect the workbook? I protect worksheets much more often than the workbook. Jack Sheet wrote: Am I right in saying that the UserInterfaceOnly setting can only be applied at Worksheet level, not Workbook level? So I have to unprotect the workbook at the start of each macro and then protect it again at the end? Seems a bit of an oversight, if so. -- Return email address is not as DEEP as it appears -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ThisWorkbook of personal.xls | Excel Discussion (Misc queries) | |||
How to use: ThisWorkbook module | Excel Programming | |||
Calling Sub(s) from ThisWorkbook | Excel Programming | |||
ThisWorkbook variables... | Excel Programming | |||
ThisWorkbook Macros | Excel Programming |