Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
This macro in Excel allows you to display or show a particular comment in Excel. This will make the desired comment visible even when you are not hovering over the cell that contains the comment. This is a great macro to use to display certain important comments throughout a worksheet or workbook in Excel.
To use the macro simply replace the A1 range cell reference with a reference to the location of the cell that contains the comment which you want to display.
Where to install the macro: Module
Excel Macro to Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
Sub Display_Single_Comment()
'This macro displays a single comment that is in Excel - means you don't have to hover over it to read it
Range("A1").Comment.Visible = True
End Sub
Subscribe for Weekly Tutorials
Helpful tutorials delivered to your email!
How to Install the Macro
- Select and copy the text from within the grey box above.
- Open the Microsoft Excel file in which you would like the Macro to function.
- Press "Alt + F11" - This will open the Visual Basic Editor - Works for all Excel Versions.
Or For other ways to get there, Click Here.
- On the new window that opens up, go to the left side where the vertical pane is located. Locate your Excel file; it will be called VBAProject (YOUR FILE'S NAME HERE) and click this.
- If the Macro goes in a Module, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Workbook or ThisWorkbook, Click Here, otherwise continue to Step 8.
- If the Macro goes in the Worksheet Code, Click Here, otherwise continue to Step 8.
- Close the Microsoft Visual Basic Editor window and save the Excel file. When you close the Visual Basic Editor window, the regular Excel window will not close.
- You are now ready to run the macro.