My application consists of a UserForm menu and several report
sheet-tabs. The problem is when the selected report opens, and the
user hovers their mouse over a cell with the comment indicator...the
comment does not appear. However when I toggle to another sheet-tab
and then back to the original report sheet-tab the comments appear as
they should.
Is there code I need to include so when a selected sheet-tab opens
all the cells with comments display the comment as they should...so
the user doesn't have to toggle on and off another sheet?
Thanks,
Rob
Is your userform modeless? If it has focus you must click the sheet to
enable sheet events. This transfers focus to the sheet. Switching
sheets isn't really necessary once your sheet behind the userform has
the focus!
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus