View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Sheet Protection Properties lost

Hi,

I have a worksheet that is protected with user defined properties (eg. allow
to insert row). To run my VBA I need to unprotect the sheet and reprotect it
with the same user defined protection settings. However the api does not
provide the hooks to get at all these settings! Am I missing something?