Excel command button to toggle comments on/off

[Rob in UK]

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.

 

[mtb'r]

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

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]

Thank you very much

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

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.