Delete Comment

[jpjjmm]

The "Delete Comments" box is grayed out on all Excel files. Even newly created ones.

[Richard Buttrey]

Do you mean it's greyed out in newly completed files or newly completed comments.

If the former then why would you expect the button NOT to be greyed out?

If the latter you need to select the comment cell first.

[jpjjmm]

It is grayed out on any selected comment cell even if I create a new file, add a comment box, then try to delete that comment box. It is also grayed out on any old file I open up and select a cell with a comment box.

[Richard Buttrey]

Hi,
Have you tried it with Excel versions newer than 2000?

[jpjjmm]

No. This has always worked before wrote the following macro:

Sub turnofcommentdelete()

'CommandBars("Cell").Controls("Delete Comment").Enabled = False

End Sub

I have removed it from the file and I still have the grayed out box. Not just in that file but any old file I open and try to delete a comment or in any completely new file I make.

[Richard Buttrey]

Hi,

When putting a question you need to tell us all the conditions that apply and anything that is relevant. Otherwise we all spend a lot of energy thinking about stuff that isn't relevant to your problem

We're not psychic (least not all the time). The fact that you've run a macro against the CommandBars is extremely relevant.

Have you tried re-instating with

'CommandBars("Cell").Controls("Delete Comment").Enabled = True

[shg]

... deleted ...

[jpjjmm]

yes I have done that earlier and still have the problem.

[Richard Buttrey]

Hi,

Are there any other factors associated with Excel or changes to your local set up that you haven't mentioned?

Have you tried getting someone else to open the workbook on another PC?

[jpjjmm]

If I had known of anything I would have checked that out. That is why I am asking for help.

The file seems to work perfect on my laptop.

[Richard Buttrey]

Which version of Excel are you using on your laptop? Is it different to your Excel 2000?