Forum Discussion

CJFoster's avatar
CJFoster
Copper Contributor
Oct 29, 2020

VBA to Activate Comment Pane in a Worksheet

Have I lost my mind or is there literally NO WAY to get a worksheet to default to a "Show Comments" view and no way to open it via VBA?  I know that navigation of comments is under CommentThreaded, but I can find NOTHING that will allow me to activate that pane.

 

excel
Macros and VBA

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Oct 29, 2020

    CJFoster 

    With your permission, if I can recommend you, add a MS Excel file (without sensitive data) to your project.

    Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

    At the same time, it is much easier for someone who wants to help to understand the subject.

    A win-win situation for everyone.

    Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

     

    * Knowing the Excel version and operating system would also be an advantage.

     

    PS. If it is Excel for web, I can already say that this is not possible.

     

    Thank you for your understanding and patience

     

     

    Nikolino

    I know I don't know anything (Socrates)

Resources