I am not sure shy you would be having that problem. Try using the On_Open and
Before_Close events in Thisworkbook (I assume your code is currently in a
standard module).
--
HTH...

Jim Thomlinson


"Baapi" wrote:

what is the event that I have to use if I need my macro's to run whenever I
open/close my workbook?

I've used "Auto_Open and Auto_Close". but, problem with this seems to be
that the open macro runs when I open the workbook but, the close macro runs
only when I close all the workbooks (or the Excel application)

how are these handled?
--
Baapi