Prevent from save if...

[Pietro]

Hi,

I want to use the ThisWorkBook BeforeSave event to prevent users from
saving the sheet if the sheet path is O:\XBOX\XBOX-Tier2\Customer
Support\Source\Reports"

 

[Bob Phillips]

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If ThisWorkbook.Path = _
"O:\XBOX\XBOX-Tier2\Customer Support\Source\Reports" Then
Cancel = True
End If
End Sub


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Pietro]

Hi Bob Phillips
Thank you for your reply...
I need exactly to do the following:
Once users try to save the sheet that has the below path ,the sheet is
automatically saved as "Tier2 Report" on the desktop ,then the sheet is
closed and the one saved on the desktop opens automatically

 

[Bob Phillips]

Which one on the desktop?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Pietro]

The one that might have been created from a previous transacion by the same
code.