On Feb 17, 12:28*pm, Gord Dibben <gorddibbATshawDOTca wrote:
I had no problem selecting all sheets and all cells then
F5SpecialCommentsOK

ReviewDelete cleared all Comments on all sheets.

Gord Dibben *MS Excel MVP

On Wed, 17 Feb 2010 11:37:18 -0800 (PST),BillCarlson



wrote:
Excel 2007

We are a small cpa firm, it is tax season... We frequently copy last
year's workbook to set-up the current year. *I'm trying to select and
delete all cell comments as part of this set-up process.

I've tried goto special and the comments section of the Review ribbon,
but I seemed to be stumped in trying to select all cells in the
workbook that contain a comment and then to delete these comments
without cycling through the next comment for each comment on the
Review ribbon.

As always, help is much appreciated,

BillCarlson- Hide quoted text -

- Show quoted text -

Hi Gord, must be doing something wrong. I have a sample workbook,
three sheets, comments in cell A1, Sheet 1, B2, Sheet2 and C3 in Sheet
3. When I select all sheets, select all cells, F5SpecialComments OK
ReviewDelete, it only deleted the comment of the active sheet --

bill