Excel for mac lock sort4/15/2023 ![]() ![]() It's far from an ideal solution however.ĥ) You could keep the sheet protected when the user is selecting the data and unprotected when the user has the header is selected. 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 |