I have a 'Protected and Shared' workbook that a group of colleagues and
myself use at work.

Problem: I want to make the 'Insert Comment' function invalid. I want it
only to become valid on clicking a programmed button on my sheet. This will
then allow a comment to be inserted. After the comment has been inserted,
the function will once again become invalid.

Q. Can you offer any advice?

Thanks in anticipation

Russ Stevens