ChrisMac1
New Member
- Joined
- Jul 15, 2024
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
HI there,
I have a workbook that, as the final code to run, I want the user to receive the save as prompt, but the filename to be made up of the values in three cells of a hidden sheet.
All the user needs to choose is a location and hit save.
Any thoughts on an easy way to do this please?
Many thanks,
Chris
BTW, I am in the UK so if I don't respond immediately be mindful of my local time please.
I have a workbook that, as the final code to run, I want the user to receive the save as prompt, but the filename to be made up of the values in three cells of a hidden sheet.
All the user needs to choose is a location and hit save.
Any thoughts on an easy way to do this please?
Many thanks,
Chris
BTW, I am in the UK so if I don't respond immediately be mindful of my local time please.