how can i disable save i need save as only

David128 · External Since: Nov 06, 2009 Posts: 1

i have a report that others use. the main bady of the report is protected
against change. but i need to disable the save so they only use save as. is
this possably

Dave Peterson · External Since: Jul 08, 2005 Posts: 16046

You could also use windows explorer to mark the file as readonly.

Be aware that the user could also change this setting.

David128 wrote:
>
> i have a report that others use. the main bady of the report is protected
> against change. but i need to disable the save so they only use save as. is
> this possably

--

Dave Peterson

Bernie Deitrick · External Since: Apr 02, 2004 Posts: 1772

David,

Save the workbook as a template, and the user will be prompted for a name
when they use save or save as, unless they specifically save the file as a
template as well.

HTH,
Bernie
MS Excel MVP

"David128" <David128.DeleteThis@discussions.microsoft.com> wrote in message
news:5708134D-2619-4A82-9970-7ED160028F45@microsoft.com...
>i have a report that others use. the main bady of the report is protected
> against change. but i need to disable the save so they only use save as.
> is
> this possably

Ms-Exl-Learner · External Since: Sep 15, 2009 Posts: 25

If you want set all the persons to do Save As then just place the cursor on
that particular file and do Right Click>>Properties>General>>Attributes>Tick
the Read Only Check box>give ok.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------

"David128" wrote:

> i have a report that others use. the main bady of the report is protected
> against change. but i need to disable the save so they only use save as. is
> this possably