M圜omment = InputBox("Enter your comments", "Comments")ĪctiveSheet.Unprotect Password:=sPassword ![]() The concept is to have the macro prompt the user for the comment text, unlock the worksheet, insert the comment, and then relock the worksheet. If you want a more granular approach to dealing with comments in protected worksheets, then you'll need to resort to using a macro. In addition, users can also modify (add, change, or delete) any other objects in the worksheet, such as drawings and charts. Note that this allows them to add comments to any cells in the worksheet, not just to those cells that you've formatted as unlocked. If you provided a password in step 3 you are prompted to reenter it, which you should do.Īny worksheet user can now add comments to cells. (Comments are considered objects in Excel.) Scroll down in the list of permissions and select the Edit Objects check box.Enter a password to be used in protecting the worksheet.(You could also click the same tool on the Review tab of the ribbon.) Excel displays the Protect Sheet dialog box. In the Cells group, click Format | Protect Sheet.Starting with an unprotected worksheet, follow these steps: ![]() The first is to simply modify how you protect your worksheet. There are a few ways you can tackle this problem. He wonders if there is a way to allow the addition of comments in protected worksheets. Doug notes that Excel allows you to add comments to cells, but only if the worksheet is unprotected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |