Forum Discussion
when exiting excel - show saveas dialog box with preset filename
I have a workbook which is 'read-only' attrib.
I needed a saveas dialog box to appear everytime save, saveas, close or the [x] at the upper left of the worksheet is clicked. but instead of "copy of filename", I want it to be a filename I will recommend.
I could not find solution in the net [I felt kinda dumb :( ]
Pls help with the vba before_close (or somewhere?) code.
many thanks
ERRATUM:
should read upper right as below (sorry for the error)
I needed a saveas dialog box to appear everytime save, saveas, close or the [x] at the upper right of the worksheet is clicked. but instead of "copy of filename", I want it to be a filename I will recommend.
