Thanks ever so much for your help Paul.
On Nov 16, 1:12 pm, Paul Schreiner wrote:
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
You can create a BeforeClose event in which you save the file before exiting.
To do it yourself,
first, record a macro in which you do a SaveAS (specify file)
Then, in the VBA editor, choose the Thisworkbook module.
In the upper left pull-down, select Workbook
in the upper right pull-down, select