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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

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,141,722
Messages
5,708,098
Members
421,546
Latest member
delatollas

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