Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 92
Default Prevent Save/Publish

I use the code below to prevent users from saving a copy of my spreadsheet
if it is opened as a Read Only document. Is there any to prevent them from
publishing the document to PDF?

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

If ActiveWorkbook.ReadOnly = True Then
msgbox "You opened this calendar as Read Only. You are not allowed to
save this document."
ThisWorkbook.Close False
End If

End Sub


Reply
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
Prevent from save if... Pietro Excel Discussion (Misc queries) 4 July 26th 08 09:40 AM
Prevent Save As CarlSprake Excel Programming 8 March 24th 06 12:28 PM
Difference between Publish and Save As Web Page in Excel 2002 johng36 Excel Discussion (Misc queries) 2 February 4th 05 07:29 PM
Prevent Particular File Name during Save ExcelMonkey[_167_] Excel Programming 1 September 28th 04 12:22 PM
Help! MsgBox and Prevent Save nrage21[_14_] Excel Programming 7 January 27th 04 09:13 PM


All times are GMT +1. The time now is 02:06 PM.

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

About Us

"It's about Microsoft Excel"