I have been trying to find a macro/VBA script for this, but have not been able to.
Basically, I want the user to be able to save an excel workbook using a pre-formatted name referenced from a cell, and be prompted to selected the path.
I am using excel 2016.
I have tried a few that I have found, but none seem to work.
Thanks in advance.
Basically, I want the user to be able to save an excel workbook using a pre-formatted name referenced from a cell, and be prompted to selected the path.
I am using excel 2016.
I have tried a few that I have found, but none seem to work.
Thanks in advance.