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