Gord Dibben brought next idea :
You should re-think this statement GS

If the workbook is saved with that sheet the active sheet then the code will
run when the file opens

Code will run only when the sheet is activated.

Opening a workbook does not activate a sheet.



Gord

Yes, you're absolutely right! Hmm.., and so I will rethink this...

--
Garry

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