Options/View/Comments Radio Buttons

Posted on 2003-02-21
Medium Priority
Last Modified: 2012-05-04
Is there a way to set "comment indicator" (.DisplayNoteIndicator = True) for 1 worksheet & "comment & indicator" ( ? ) for another worksheet?
Question by:WILSONRM
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Expert Comment

ID: 7998786
What programming language are you talking about?

I know a DisplayNoteIndicator property in Excel's VBA but that's an application property so the answer would be NO. The best thing you can do, I think is use the Activate and Deactivate events of the worksheet to set the property's value to whatever you want.

But again I ask you: what programming language are we talking about?


Author Comment

ID: 7998983
So there is no setting for comment & indicator for VBA in excel?

Accepted Solution

pauloaguia earned 140 total points
ID: 8000340
This is what I got when I recorded a macro in Excel with me setting all the options available:

    Application.DisplayCommentIndicator = xlCommentIndicatorOnly
    Application.DisplayCommentIndicator = xlNoIndicator
    Application.DisplayCommentIndicator = xlCommentAndIndicator

These three are probably constants defined in the VBA library for Excel.

Macro recording can be very helpfull if you want to find out out to do something in VBA that you already know how to do in Excel.

Hope this helps


By the way: if this is an Excel question it was probably better of at the Microsoft Office TA: http://www.experts-exchange.com/Applications/MS_Office/


Author Comment

ID: 8000986
Thanks Paulo for your help!!

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is an easy way, in .NET, to centralize the treatment of all unexpected errors. First of all, instead of launching the application directly in a Form, you need first to write a Sub called Main, in a module. Then, set the Startup Object to th…
This article will show, step by step, how to integrate R code into a R Sweave document
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question