How to excute a macro on opening a worksheet?

Posted by Mick on November 16, 2001 6:51 AM

I want to excute a macro every time I open the excel worksheet, how to do that?

Thanks.

Posted by lenze on November 16, 2001 6:57 AM

Use the On open event procedure. Place your macro (or reference to it) in the This Workbook module and select On open.

Posted by NIuB on November 16, 2001 7:10 AM

Try this :

place this in your workbook event (not normal module)

private sub workbook_open()
'place your code name below this line

end sub

HTH