View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default How can I create a document that can be wrote on but not saved?

Templates will always fire a save as, rather than a save, if that's what
your looking for. Just save your file as a template.

If this is nor suitable, you could have a workbook_beforesave event, which
could then be canceled totally here, or cancelled unless the user selects
save as...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"dctech" wrote in message
...
I am wanting to create a document that I can put on our website that can be
written on but not saved. (ie. time sheets, milage sheets)