Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Allow users to edit ranges when protecting worksheet
Moving the code that sorted by priority to Workbook_BeforeSave was the trick. Thank you!- Adgat
- Post #3
- Forum: Microsoft: Office
-
Allow users to edit ranges when protecting worksheet
I have a spreadsheet that sorts and reorders data automatically after a user makes a change to the data. This is done through Private Sub Worksheet_Change. Part of the code is to unprotect the sheet and than protect it again after changes have been made. I am using the 'Allow users to edit...- Adgat
- Thread
- Replies: 3
- Forum: Microsoft: Office
