Record a macro do do what you want, then put it in the Workbook Open module
so it will run as soon as the Workbook is opened.

If you're new to macros, check David McRitchie's site
http://www.mvps.org/dmcritchie/excel/excel.htm

Event, Change_Cell Events
Worksheet events provide a means of automatically triggering a macro when
something happens on the worksheet. (change, calculation, double-click,
right-click, selection change, worksheet become active or is deactivated, and
follow hyperlink).


hth
Vaya con Dios,
Chuck, CABGx3



"SITO" wrote:


Anyone with a good idea how to trigger a refresh of a .bqy when opening
workbook ?


--
SITO
------------------------------------------------------------------------
SITO's Profile: http://www.excelforum.com/member.php...o&userid=37529
View this thread: http://www.excelforum.com/showthread...hreadid=571742