Increment on open, prompt to save if printing

Hi All,

I am having problems getting my VBA to work when I attempt this, I am quite the novice into VBA, and I have problems with the whole prompt to save if I print.

The idea is for a quotation template, where we have the quotation number i J6, which I want to increment whenever the file is opened. The idea is then that if we print the quotation (as PDF - but I can accept a prompt to save when printing really) it asks to save the file so that upon the next use of the file, the quotation number is not the same.

Any ideas?

Thanks,
Peter

Shameless bump, anyone?