Colin Hayes presented the following explanation :
Hi All

I have a worksheet upon which I use the 'Refresh All' command to receive data
from an external source. It works well.

I also like to insert Comments on the sheet. I find however that when I use
the 'Refresh All' command the formatting of the sheet is changes such that
the 'Insert Comment' link disappears from the context menu.

How can I stop the Refresh All command changing the format of my sheet , and
leave me the option to insert a Comment?

I tried to use the data Range Properties command on the External Data
toolbar , but it is constantly greyed out.

Grateful for any ideas...

Try...

In the Sheet_BeforeRightClick event:

Commandbars("Cell").Reset

--
Garry

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