VBA to Activate Comment Pane in a Worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1834143%22%20slang%3D%22en-US%22%3EVBA%20to%20Activate%20Comment%20Pane%20in%20a%20Worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1834143%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20I%20lost%20my%20mind%20or%20is%20there%20literally%20NO%20WAY%20to%20get%20a%20worksheet%20to%20default%20to%20a%20%22Show%20Comments%22%20view%20and%20no%20way%20to%20open%20it%20via%20VBA%3F%26nbsp%3B%20I%20know%20that%20navigation%20of%20comments%20is%20under%20CommentThreaded%2C%20but%20I%20can%20find%20NOTHING%20that%20will%20allow%20me%20to%20activate%20that%20pane.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CJFoster_0-1603993328690.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F230184i89FA8455A0776F52%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CJFoster_0-1603993328690.png%22%20alt%3D%22CJFoster_0-1603993328690.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1834143%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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.

CJFoster_0-1603993328690.png

 

1 Reply
Highlighted

@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)