Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel "Delete Comment" Functionality Disabled

Status
Not open for further replies.

T111

Programmer
Jun 28, 2003
91
IE
Hi,
I have a user who is unable to delete a comment. Even when they open a new spreadsheet they are allowed to Insert/Edit a comment but the "Delete comment" button is visible but disabled. Does anyone know the code to put back in this functionality?
Thanks,
T111!
 
It's a case-sensitive functionality. Is there a comment in selected cell?

combo
 
Yes there is a comment in the cell but when they right click the "Delete Comment" option is visible but disabled. They can change the comment but not allowed to delete it.
 
If it was disabled by macro, try to execute (either in macro or immediate window):
Code:
Application.CommandBars.FindControl(Type:=msoControlButton, ID:=1592).Enabled = True
Have one excel instance opened, just for saving settings, close and reopen excel next.

combo
 
For each control, incl. the popup menu:
Code:
For Each c In Application.CommandBars.FindControls(Type:=msoControlButton, ID:=1592)
    c.Enabled = True
Next c

combo
 
Thanks combo worked like a charm :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top