View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gordon[_2_] Gordon[_2_] is offline
external usenet poster
 
Posts: 211
Default Lock down a wokbook

Hi...

I have a 32 sheet workbook that my users input quite freely. However, when
they have completed their input I want to hit a button that will freeze all
data and refuse any more changes/user input. I'd use protect workbook but the
book is intricate and changing all the cell properties would be a nightmare...

Thanks in advance G