I currently have code that populates a cell (A1 in a sheet named "File Name"). Is there a way to:

1.) Use the population of A1 (when my other code executes) as a trigger to name the workbook?
2.) Not save the workbook to a specific location (just rename it), so that the user can choose where to save it.

This is for a template that I built that is used by several people. I don't care where they save it, but I do care that everyone follows a consistent naming convention.

I don't understand how this would be possible, but you guys have amazed me in the past, so I figured I'd give it a shot. Plus, CHAT GPT tells me it is possible, but has not given me correct code to do it yet!

Thanks