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
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
