Hi Everyone,
i would appreciate for this, I require a vba when I save it should just save the file and when i press Save As it should run some procedure and prompt a dialogue to Save As file.
Why do you need VBA ??
Save and SaveAs already work as you have requested......EXCEPT for the very first time it is saved, when the workbook is still caleed Book1, Book2 etc !!
Thanks for your reply,
i agree it is working provided if you don't run any procedure during save. if you add any procedure in before save then it always run whether you want to save or save as it always run. i need a vba when i press that procedure should not run which i have it in before save and it should just save file but when i press save as then it should ask a file by running that procedure.
on Save system should just save file
on Save As system should run before save event and then ask for savging file.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.