Thread: How do I unprotect/with password to run marco and protect
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J_Will[_2_] J_Will[_2_] is offline
external usenet poster
  
Posts: 1
Default How do I unprotect/with password to run marco and protect
I have a locked sheet with columns unlocked for users to populate. I have it
protected with a password so users can only update certain cells. I wrote a
macro to sort data when entries are completed by clicking a button. How can
I unprotect it with password, run macro, and protect it with password after
sort is complete
Reply With QuoteReply With Quote