![]() For example, detect and revert changes using Worksheet_Change. I think there are two methods, either (1) get the code to unprotect the sheet, apply the sort, then re-protect the sheet, or (2) have the sheet protected using UserInterfaceOnly:=True.ģ) Lorie's answer which does not allow users to select cells ( )Ĥ) One solution that I haven't seen discussed is using VBA to provide some basic protection. There are other posts explaining how to do this. Your options are:Ģ) Apply protection and create buttons with code to sort using VBA. The prevailing answer is that you can't protect content from editing while allowing unhindered sorting. There are a number of people with this difficulty.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |