Initialising values

[Alec Kolundzic]

How can I initialise values in a number of cells on first
opening a sheet, the nearest I can get to it is to use the
worksheet object event - Worksheet_Activate(), this only
works when I open another sheet then return back to the
sheet in which I want the values initialising.

Thanks
Alec

 

[Nikos Yannacopoulos]

Alec,

Try the Workbook_Open event instead.

HTH,
Nikos

 

[Alec Kolundzic]

Thanks Nikos
Your solution works a treat.

-----Original Message-----
Alec,

Try the Workbook_Open event instead.

HTH,
Nikos




.