View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] adambush4242@hotmail.com is offline
external usenet poster
 
Posts: 168
Default Using a Check Box to Lock/Unlock Cells

I created a check box and want to link a macro to it. My worksheet is going
to be protected at all times. The macro needs to unlock a certain range of
cells when the check box is checked on, and re-lock the cells when the box is
unchecked. Any Ideas?

Thanks

Adam Bush