View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Sheet Jack Sheet is offline
external usenet poster
 
Posts: 47
Default 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