View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
DTTODGG
 
Posts: n/a
Default Disallow "SAVE" only "SAVE AS" or prompt

OK, so a template does work!
Sorry to waste bit bucket space.

So many questions, so little time!

"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