ActiveWorkbook.Save DOESNT WORK !!
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!
|