MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can I automatically run a macro when I open a workbook?


Posted by Cam Watson on December 02, 1999 1:20 PM

Hi there,

I need to run a macro when I open a workbook in Excel 97. A 3rd party program is opening the workbook to update it from to time. I was hoping that I could write a macro to print out sections when cell values reach a certain level. I need to find a way to have this marco run without any user intervention... any suggestions?

Thanks for your time.

Cam


Posted by Ivan Moala on December 05, 1999 1:52 AM


Look @ online Help in the VBA editor for
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range)

For help on event procedures look @ this site
http://home.gvi.net/~cpearson/excel.htm .


Ivan

Posted by Wayne on December 17, 1999 10:45 PM

Try this web page.

http://www.vbapro.com/xl_condformat.htm