Google Answers Logo
View Question
 
Q: Excel command button to toggle comments on/off ( No Answer,   4 Comments )
Question  
Subject: Excel command button to toggle comments on/off
Category: Computers > Software
Asked by: robuklb3412-ga
List Price: $3.00
Posted: 19 Sep 2006 06:22 PDT
Expires: 19 Oct 2006 06:22 PDT
Question ID: 766559
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.
Answer  
There is no answer at this time.

Comments  
Subject: Re: Excel command button to toggle comments on/off
From: reinedd-ga on 19 Sep 2006 07:44 PDT
 
Sub Macro1()
    Application.DisplayCommentIndicator = xlCommentAndIndicator
End Sub
Subject: Re: Excel command button to toggle comments on/off
From: robuklb3412-ga on 19 Sep 2006 08:33 PDT
 
That turns the comments on. But then it doesnt turn them off again?
Subject: Re: Excel command button to toggle comments on/off take 2
From: reinedd-ga on 19 Sep 2006 08:47 PDT
 
Sub Macro1()
If Application.DisplayCommentIndicator = xlCommentIndicatorOnly Then
    Application.DisplayCommentIndicator = xlCommentAndIndicator
    Else
    Application.DisplayCommentIndicator = xlCommentIndicatorOnly
End If
End Sub
Subject: Re: Excel command button to toggle comments on/off
From: robuklb3412-ga on 19 Sep 2006 09:04 PDT
 
It works - thank you very much

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy