It seems that Excel comments will only appear if you select a cell or mouse over it. How can you make comments appear when you TAB into a cell?
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Comments (Excel 2000)
Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Comments (Excel 2000)
- This topic has 13 replies, 5 voices, and was last updated 20 years, 7 months ago.
AuthorTopicWScowboyfan
AskWoody LoungerOctober 24, 2004 at 12:51 pm #411390Viewing 5 reply threadsAuthorReplies-
WSErrolv
AskWoody LoungerOctober 24, 2004 at 1:40 pm #891481Cowboy,
Welcome to Woody’s Lounge!(At least in Excel 2000) I could find no View option to show comments only when a cell has focus. Here’s a short macro that does that, though. Just set up something to flag the particular cells/range that you need to show comments and put it in where I have “$B$4”. (There’s probably better ways. They’ll show up on this board)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Address = (“$B$4”) Then
Application.DisplayCommentIndicator = xlCommentAndIndicator
Else
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
End If
End SubErrol
-
WScowboyfan
AskWoody Lounger -
WSBAN
AskWoody LoungerOctober 25, 2004 at 3:27 pm #891813Does this do what you want?
It ran kind of slow on my machine, but I’m working with 30 workbooks open at the time, so maybe that’s my problem. Perhaps it could be written better as well…
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
On Error GoTo errhandler
If ActiveCell.Comment.Visible = False Then
ActiveCell.Comment.Visible = True
End Iferrhandler:
End Sub -
WSBAN
AskWoody LoungerOctober 25, 2004 at 4:06 pm #891829I got to thinking about it and the IF was actually unnecessary…this should do the same thing with less code. They both do what you wanted, though.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
On Error Resume Next
ActiveCell.Comment.Visible = True
End Sub -
WScowboyfan
AskWoody Lounger -
WScowboyfan
AskWoody Lounger
-
-
-
WSBAN
AskWoody LoungerOctober 25, 2004 at 3:27 pm #891814Does this do what you want?
It ran kind of slow on my machine, but I’m working with 30 workbooks open at the time, so maybe that’s my problem. Perhaps it could be written better as well…
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
On Error GoTo errhandler
If ActiveCell.Comment.Visible = False Then
ActiveCell.Comment.Visible = True
End Iferrhandler:
End Sub
-
-
WScowboyfan
AskWoody Lounger
-
-
WSErrolv
AskWoody LoungerOctober 24, 2004 at 1:40 pm #891482Cowboy,
Welcome to Woody’s Lounge!(At least in Excel 2000) I could find no View option to show comments only when a cell has focus. Here’s a short macro that does that, though. Just set up something to flag the particular cells/range that you need to show comments and put it in where I have “$B$4”. (There’s probably better ways. They’ll show up on this board)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Address = (“$B$4”) Then
Application.DisplayCommentIndicator = xlCommentAndIndicator
Else
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
End If
End SubErrol
-
macropod
AskWoody_MVP -
macropod
AskWoody_MVP -
WSsdckapr
AskWoody Lounger -
WSsdckapr
AskWoody Lounger
Viewing 5 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
“kill switches” found in Chinese made power inverters
by
Alex5723
1 hour, 33 minutes ago -
Windows 11 – InControl vs pausing Windows updates
by
Kathy Stevens
1 hour, 59 minutes ago -
Meet Gemini in Chrome
by
Alex5723
3 hours ago -
DuckDuckGo’s Duck.ai added GPT-4o mini
by
Alex5723
3 hours, 9 minutes ago -
Trump signs Take It Down Act
by
Alex5723
11 hours, 8 minutes ago -
Do you have a maintenance window?
by
Susan Bradley
2 hours, 22 minutes ago -
Freshly discovered bug in OpenPGP.js undermines whole point of encrypted comms
by
Nibbled To Death By Ducks
2 hours, 24 minutes ago -
Cox Communications and Charter Communications to merge
by
not so anon
14 hours, 27 minutes ago -
Help with WD usb driver on Windows 11
by
Tex265
19 hours, 37 minutes ago -
hibernate activation
by
e_belmont
23 hours, 23 minutes ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
1 day, 3 hours ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
1 day, 6 hours ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
1 day, 6 hours ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
2 hours, 21 minutes ago -
Out of band for Windows 10
by
Susan Bradley
1 day, 11 hours ago -
Giving UniGetUi a test run.
by
RetiredGeek
1 day, 17 hours ago -
Windows 11 Insider Preview Build 26100.4188 (24H2) released to Release Preview
by
joep517
2 days, 1 hour ago -
Microsoft is now putting quantum encryption in Windows builds
by
Alex5723
2 hours, 25 minutes ago -
Auto Time Zone Adjustment
by
wadeer
2 days, 6 hours ago -
To download Win 11 Pro 23H2 ISO.
by
Eddieloh
2 days, 3 hours ago -
Manage your browsing experience with Edge
by
Mary Branscombe
3 hours, 12 minutes ago -
Fewer vulnerabilities, larger updates
by
Susan Bradley
20 hours, 44 minutes ago -
Hobbies — There’s free software for that!
by
Deanna McElveen
1 day, 3 hours ago -
Apps included with macOS
by
Will Fastie
1 day, 1 hour ago -
Xfinity home internet
by
MrJimPhelps
21 hours, 48 minutes ago -
Convert PowerPoint presentation to Impress
by
RetiredGeek
1 day, 23 hours ago -
Debian 12.11 released
by
Alex5723
3 days, 3 hours ago -
Microsoft: Troubleshoot problems updating Windows
by
Alex5723
3 days, 6 hours ago -
Woman Files for Divorce After ChatGPT “Reads” Husband’s Coffee Cup
by
Alex5723
2 days, 10 hours ago -
Moving fwd, Win 11 Pro,, which is best? Lenovo refurb
by
Deo
2 hours, 36 minutes ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.