Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent from save if...
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" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent from save if...
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" wrote in message ... 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" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent from save if...
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" wrote: 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" wrote in message ... 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" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent from save if...
Which one on the desktop?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pietro" wrote in message ... 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" wrote: 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" wrote in message ... 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" |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent from save if...
The one that might have been created from a previous transacion by the same code. "Bob Phillips" wrote: Which one on the desktop? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Pietro" wrote in message ... 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" wrote: 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" wrote in message ... 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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) |