Thread
:
protect unprotect toggle VBA
View Single Post
#
5
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett