On Sheet1, I have multiple Worksheet_Change events based on a user making some selections which hides/unhides rows and columns on other worksheets.
All of these other worksheets are password protected, and this is preventing the code from executing. What's the solution?
Do I need to add this somewhere? UserInterFaceOnly:=True Where? Just once for the Worksheet_Change, or once per If / End If statement?
Or do I need to specify the password to unprotect and reprotect? Again, just once for the Worksheet_Change, or once per If / End If ?
Thanks
All of these other worksheets are password protected, and this is preventing the code from executing. What's the solution?
Do I need to add this somewhere? UserInterFaceOnly:=True Where? Just once for the Worksheet_Change, or once per If / End If statement?
Or do I need to specify the password to unprotect and reprotect? Again, just once for the Worksheet_Change, or once per If / End If ?
Thanks