View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kcdonaldson
 
Posts: n/a
Default Unprotecting 4 sheets before "WorkbookOpen" macro runs

i am trying to run a workbookopen macro but i keep getting an error staing
that i am trying to edit a protected worksheet or cell. I do have all of the
worksheets in this workbook protected but i am trying to run a macro to clear
certain cells at open . Can someone tell me how to write it so that it
unprotects all of the worksheets before it tries to clear the cells?