Thread: Protect/unprotect all sheets at once?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Protect/unprotect all sheets at once?
for each sh in sheets
sh.unprotect
next sh

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"wx4usa" wrote in message
...
Is there a way to protect or unprotect all sheets at once without
going into each sheet?

Reply With QuoteReply With Quote