How to create a comment box when the sheet is protected, as insert button is greyed out?

Good morning Excel-7878

If you want someone to look at some code, then paste it into your main question, using the # button to place code tags around it - as you have supplied it, it is virtually unreadable in a Word document.

You are correct in that it is not possible to add a comment whilst sheet is protected, however you can edit a comment whilst it is unprotected.
This is perfect territory for the macro recorder. Just record your actions for unprotecting a sheet, inserting a comment, then re-protect it again.
If you have ever seen other files insert a comment into a protected sheet, then this is how it's done.

If you need further assistance, post your recorded code up here, and someone will take a look.

HTH

DominicB

Thanks, I'll try to repost with the # now..

The spreadsheet actually needs to stay in protected mode (with only a few cells unlocked) as I will not be the only person using it.


Any advice would be great?

Hi Excel-7878

Thanks for posting the code - this is much better to read.

You're going to have to spell out what the issue is - you're asking for code, and then providing code.
You say that the worksheet is to remain protected, but my proposed solution is to leave it unlocked only long enough for the comment to be put in place.

In your "edit add, delete comment code" section the password needs to be in quotes - you've done this on the insert comment code, while the remove comment code doesn't unprotect the sheet, so shouldn't work.

Can you upload a workbook with this code in place - you can delete all the information, just leave a few rows of dummy information so I can see what you're trying to achieve.

HTH

DominicB

I have created a class attendance sheet that has different coding and features in there, which I will be sharing with staff. The worksheet and individual sheets will need to remain protected/locked when I share it so that staff do not alter the coding/features etc; with the exception of a few unlocked cells that they can type into.

Because the staff won't have the password to unlock the protected worksheets themselves, they will need an alternative way to make 'additional' comments inside certain cells. I.e. on an unlock sheet they can usually right clicked on the mouse button and select 'insert comment' to make a comment.

However, because the sheets will be locked and they won't personally be able to unlock the sheets, they will need an alternative way to make comments because the above option is not accessible on a 'protected/locked' sheet.

I managed to research and find the above mentioned coding, however I could not get it working. I have added the quote marks around the 'dummy' password as suggested, but for some reason I am still unable to make a comment; or figure out how I am suppose to add, edit or delete the comment to be precise.

If any one has any advice on the above code, or even an alternative code that will allow me to add, edit and remove comments in protected cells automatically that would be great.

Thank you.