We're using a number of Excel workbooks as input forms to an application.
The workbooks are normally opened as Read-only have their own "Save" buttons
which use Save As to make a copy of the workbook with a name constructed from
the context of what the user has entered into key cells. However the normal
Excel File->Save and toolbar icon are still there and if the someone uses
them they will get the Excel Save As dialog and suggested name "Copy of
.....xls" which we don't want. Ideally we'd like to switch the normal
behaviour to our own code.
Any ideas?
Niall
--
Making IT simpler and better

Are the "Save" buttons from the Forms Toolbar or the Control Toolbox?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Niall Young" <(E-Mail Removed)>
wrote in message
We're using a number of Excel workbooks as input forms to an application.
The workbooks are normally opened as Read-only have their own "Save" buttons
which use Save As to make a copy of the workbook with a name constructed from
the context of what the user has entered into key cells. However the normal
Excel File->Save and toolbar icon are still there and if the someone uses
them they will get the Excel Save As dialog and suggested name "Copy of
.....xls" which we don't want. Ideally we'd like to switch the normal
behaviour to our own code.
Any ideas?
Niall
--
Making IT simpler and better

Forms Toolbar
Niall
--
Making IT simpler and better


"Jim Cone" wrote:

> Are the "Save" buttons from the Forms Toolbar or the Control Toolbox?
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
>
>
> "Niall Young" <(E-Mail Removed)>
> wrote in message
> We're using a number of Excel workbooks as input forms to an application.
> The workbooks are normally opened as Read-only have their own "Save" buttons
> which use Save As to make a copy of the workbook with a name constructed from
> the context of what the user has entered into key cells. However the normal
> Excel File->Save and toolbar icon are still there and if the someone uses
> them they will get the Excel Save As dialog and suggested name "Copy of
> .....xls" which we don't want. Ideally we'd like to switch the normal
> behaviour to our own code.
> Any ideas?
> Niall
> --
> Making IT simpler and better
>

Niall,
Place this code in the "ThisWorkbook" module. It should do what you want...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Not TypeName(Application.Caller) = "String" Then
MsgBox "Please use the Save button on the worksheet. ", vbExclamation, " Blame Niall"
Cancel = True
End If
End Sub
-----------
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html




"Niall Young"
<(E-Mail Removed)>
wrote in message
Forms Toolbar
Niall
--
Making IT simpler and better




"Jim Cone" wrote:
> Are the "Save" buttons from the Forms Toolbar or the Control Toolbox?
> --
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware







> "Niall Young" <(E-Mail Removed)>
> wrote in message
> We're using a number of Excel workbooks as input forms to an application.
> The workbooks are normally opened as Read-only have their own "Save" buttons
> which use Save As to make a copy of the workbook with a name constructed from
> the context of what the user has entered into key cells. However the normal
> Excel File->Save and toolbar icon are still there and if the someone uses
> them they will get the Excel Save As dialog and suggested name "Copy of
> .....xls" which we don't want. Ideally we'd like to switch the normal
> behaviour to our own code.
> Any ideas?
> Niall
> --
> Making IT simpler and better
>