Reset cell values to Zero

Posted by Skooter on October 12, 2001 12:55 PM

I have a dozen or so cells on several worksheets that I need to be reset BACK to zero when the workbook opens. Any ideas ?

Thanks,
Skooter

Posted by Todd on October 12, 2001 12:59 PM

Go into the Thisworkbook item in the project window. use drop down menus at top to select workbook in the left one and Open in the right one. Any code you type in will run when you open the workbook.