Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Slintz,
In the VBE, select the workbook's ThisWorkbbook module and look for a Workbook_BeforeSave code something like: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean) 'possible code lines Cancel = True <<==== LOOK FOR THIS 'possible additional cde End Sub The marked line, as might intuitively be expected, cancels any save operation, --- Regards, Norman "slintz" wrote in message ... Any ideas why a workbook Save method would fail to actually save without raising any errors? Just after, the "Saved" property remains FALSE (at least that much makes sense) - but I have no ideas what to look for / verify. TIA! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why doesn't While ActiveWorkBook < Null work? | Excel Discussion (Misc queries) | |||
save as mode doesnt work | Excel Discussion (Misc queries) | |||
Can't get ActiveWorkbook.Container to work | Excel Programming | |||
troubles with ActiveWorkbook.Save | Excel Programming | |||
protect module and work in activeworkbook | Excel Programming |