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

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

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