|
|
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. |
|
There is no answer at this time. |
|
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 |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |