Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent from save if... | Excel Discussion (Misc queries) | |||
Prevent Save As | Excel Programming | |||
Difference between Publish and Save As Web Page in Excel 2002 | Excel Discussion (Misc queries) | |||
Prevent Particular File Name during Save | Excel Programming | |||
Help! MsgBox and Prevent Save | Excel Programming |