| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling SAVE AS Temporarily
Glad to hear it worked!
--JP On Jan 8, 12:04*am, monir wrote: Perfect! *Thank you very much. "JP" wrote: How about Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI Then MsgBox ("The 'Save As' function has been disabled."), vbInformation, "Save As Disabled" Cancel = True End If End Sub HTH, JP On Jan 7, 9:34 pm, monir wrote: Hello; I need to disable the File option Save As while the file test.xls is open, and return to normal File options on exit. How to do that ?? The following w/b event DOES NOT produce the desired effect: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 'MS Excel help: SaveAsUi True if the Save As dialog box will be displayed * * SaveAsUI = False End Sub Thank you.- Hide quoted text - - Show quoted text - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disabling effects of cells (temporarily) | Excel Programming | |||
| Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
| Disabling Save Function | Excel Discussion (Misc queries) | |||
| Disabling Save Pop-Up | Excel Programming | |||
| Temporarily Disabling an Event Macro | Excel Programming | |||
![JP[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
