LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Saving a very tricky code

Hi
I have a very tricky situation. I want to disble the save option of the workbook. So I wrote this cod

Private Sub Workbook_BeforeClose(Cancel as Boolean

Application.DisplayAlerts = Fals
ThisWorkbook.Saved = Tru
ThisWorkbook.Clos
Application.DisplayAlerts = true

End Su

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,
Cancel as Boolean

Application.DisplayAlerts = Fals
Cancel = Tru
Application.DisplayAlerts = tru

End Su

Now the problem is the moment I write this code, it is activated before saving and this code is not saved at all. How do I save this code? My objective is that the user should not be able to save any changes in the workbook
TI
Shilps
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Vba Code Rick, United Kingdom Excel Discussion (Misc queries) 5 September 8th 05 08:51 PM
code lost after saving Glen[_3_] Excel Programming 2 October 29th 03 03:05 PM
Saving a Workbook without code KimberlyC Excel Programming 1 August 21st 03 07:07 PM
Code for saving as a .prn file Jim Rech Excel Programming 0 August 5th 03 01:38 PM
code for saving Pier Excel Programming 2 July 29th 03 12:25 PM


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"