Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / General Excel Questions / July 2008

Tip: Looking for answers? Try searching our database.

Prevent from save if...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pietro - 23 Jul 2008 07:55 GMT
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 to this Message
Bob Phillips - 23 Jul 2008 08:30 GMT
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

Signature

HTH

Bob

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

> 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 to this Message
Pietro - 23 Jul 2008 10:07 GMT
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

> Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
> Boolean)
[quoted text clipped - 9 lines]
> > saving the sheet if the sheet path is O:\XBOX\XBOX-Tier2\Customer
> > Support\Source\Reports"
Reply to this Message
Bob Phillips - 24 Jul 2008 19:22 GMT
Which one on the desktop?

Signature

HTH

Bob

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

> Hi Bob Phillips
>   Thank you for your reply...
[quoted text clipped - 16 lines]
>> > saving the sheet if the sheet path is O:\XBOX\XBOX-Tier2\Customer
>> > Support\Source\Reports"
Reply to this Message
Pietro - 26 Jul 2008 09:40 GMT
The one that might have been created from a previous transacion by the same
code.

> Which one on the desktop?
>
[quoted text clipped - 18 lines]
> >> > saving the sheet if the sheet path is O:\XBOX\XBOX-Tier2\Customer
> >> > Support\Source\Reports"
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.