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), Bill Carlson
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,

Bill Carlson

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

You did nothing wrong.

My testing was faulty.

Apologies for that.

I see you have gone with Micky's macro which does the job.


Gord

On Sat, 20 Feb 2010 16:15:55 -0800 (PST), Bill Carlson
wrote:

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