View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default protect unprotect toggle VBA


As ALWAYS, post YOUR code for comments and suggestions.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Wanna Learn" wrote in message
...
Hello I want to create a checkbox that when the box is checked rows 1
thru
70 are protected and when the box is unchecked worksheet is unprotected.
I
created a macro to protect the sheet, then I created a macro to unprotect
the
sheet . I combined both macros but it does not toggle. Thanks in advance