You're welcome. It would drive me mad having a comment appear eveytime I
selected a cell.

"Caroline" wrote:

Rowan - Thank you ever so much for that. Much appreciated!!!!


"Rowan" wrote:

Look in DataValidationInput Message.
There is a clear all button but this only seems to work for the selected cell.
If I select a range of cells with different validation messages and go into
DataValidation I get a option to remove all data validation which may have
the desired effect for you.

Hope this helps
Rowan

"Caroline" wrote:

I am currently working on a worksheet created by someone else so am not sure
how this is done.

When I click on any cell in the worksheet- the office assistant appears with
comments relating to data that needs to be entered into the cell.

Can someone please tell me how to stop this from appearing. I have tried
turning off the Office Assistant but the comments still appear It seems like
every column in the spreadsheet has a different comment with relevant input
instructions.

I have looked under all the help topics regarding comments...but none of
them apply. Am not really sure where to look now!

Please help