| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable 'Save/Save As', Enable 'Save as PDF'
Perhaps a better way to handle the event...
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True: SaveAs_PDF End Sub -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable Save/Save As - not working? | Excel Discussion (Misc queries) | |||
| Enable/Disable SAVE AS button from code | Excel Programming | |||
| Disable save & save as then return message... | Excel Programming | |||
| disable save and saveas from menubar and save via command button | Excel Programming | |||
| Disable save, save as, but allow save via command button | Excel Programming | |||
![GS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
