on 6/17/2011, Colin Hayes supposed :
In article , GS writes
Hi Colin,
You can use the wks event behind ThisWorkbook OR the associated event behind
the worksheet[s]
containing the imported data. In both cases, the action loads the menu so
you can
access it via
code. In your case, though, Reset (works anytime, whether the menu is loaded
or
not) may not
work as expected and so you could set the "Insert Comment" menu's Visible
prop
as follows...

CommandBars("Cell").Controls("Insert Comment").Visible = True


<FYI
I've implemented similar concept in our Calendar project to handle the
CommentCover feature,
whereby the "Insert/Delete Comment" menuitems are appropriately replaced
with
our own
menuitem. n our project I use the Sheet_BeforeRightClick event behind
ThisWorkbook so it works
on all project sheets. If you only have one or two sheets with imported data
then
you'd want to use
Worksheet_BeforeRightClick behind the appropriate sheet.

--
Garry

Hi Garry

OK thanks for that.

No joy , I'm afraid. The use of the Refresh All icon continues to remove the
formatting permissions which were previously in place. It's not clear why.
Excel can be very frustrating at times, I find , but I'll stick at it.


Best Wishes

By what means was your 'formatting permissions' in place? Are you
talking about sheet protection permissions? If so, simply reset them as
exampled in our Calendar project. (What I suspect is going on is the
RefreshData process is simply reapplying protect without your
permission settings, though I don't understand the why/how of that!)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc