MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Autosave


Posted by Scott on August 01, 2001 6:25 AM

I use the same workbook every day to keep a record of all details of deliveries that arrive. I activate autosave each day and remove the prompt option.

Is there anyway to have the autosave settings start automatically when I start excel or when I open that particular workbook ?

I am using Excel 2000 and running Win98.
Thanks for any info.


Posted by Joobor on August 01, 2001 6:38 AM

Place this code in your module :


sub auto_open()
thisworkbook.save
end sub

hth

Posted by Scott on August 01, 2001 10:25 AM

Thanks that seems to have done the trick.