Sorry all. I misinformed you. The workbook is 'shared' but not
protected. To remove from shared use requires a password. This is
suffice for me as it effectively locks my programming.
The problem I have is that I have a button which when activated,
inserts a comment. This is then recorded as it is a shared book.
Inserting a comment by using a drop-down or the menu bar works but the
comment is not recorded. I need all comments to be recorded therefore
all users must use the my button. However, many users have a
preference to insert comments in the regular way. I therefore require
this function to be redundant.
Does this make sense??