Excel command button to toggle comments on/off

Rob in UK

New Member
Joined
Sep 19, 2006
Messages
2
In Microsoft Excel, how do I put a command button to toggle comments on/off?
I know Commnennts can be on/off via the Review tool bar option. I just
want to have a command button on the middle of the spreadsheet to do
this instead.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

mtb'r

New Member
Joined
Sep 8, 2006
Messages
42
First, I'd create a macro to toggle between showing and not showing comments:

Code:
Sub ToggleComment()
    'Macro created by 4XL Solutions on 9/19/06
    If Application.DisplayCommentIndicator = xlCommentAndIndicator Then
        Application.DisplayCommentIndicator = xlCommentIndicatorOnly
    Else
        Application.DisplayCommentIndicator = xlCommentAndIndicator
    End If
End Sub

Then, I would create a button (View-> Toolbars-> Forms, then select and draw a button). When prompted, point your button to run the ToggleComment macro.
 

Rob in UK

New Member
Joined
Sep 19, 2006
Messages
2
Thank you very much

First, I'd create a macro to toggle between showing and not showing comments:

Code:
Sub ToggleComment()
    'Macro created by 4XL Solutions on 9/19/06
    If Application.DisplayCommentIndicator = xlCommentAndIndicator Then
        Application.DisplayCommentIndicator = xlCommentIndicatorOnly
    Else
        Application.DisplayCommentIndicator = xlCommentAndIndicator
    End If
End Sub

Then, I would create a button (View-> Toolbars-> Forms, then select and draw a button). When prompted, point your button to run the ToggleComment macro.
 

Forum statistics

Threads
1,143,637
Messages
5,719,969
Members
422,252
Latest member
wannabegeek1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top