Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |