OK - I want to be a bit fancier now.

I have a template. I would like to force the file to be saved by the name it
a cell (J2). So, when they want to save the file, they just click on save or
save as, the template prompts them for a name, the name is already filled in
as the name in cell J2, they just confirm it.

Thank you for teaching me a lot and making me look good!

"DTTODGG" wrote:

Hello-

I have built a form using excel. I have protected all cells except user
inputs.

I'm wondering if there is a way to force the user to either exit without
saving or use "save as". I guess that sort a makes this file a template.

Either way, I would appreciate your wisdom on how to solve this dilema.

I have only poked around with macros and vba so be very specific.
Thank you kindly