LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default 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!



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why doesn't While ActiveWorkBook < Null work? [email protected] Excel Discussion (Misc queries) 3 May 27th 07 12:05 AM
save as mode doesnt work seachange49 Excel Discussion (Misc queries) 0 April 26th 06 09:26 PM
Can't get ActiveWorkbook.Container to work Ken Valenti Excel Programming 3 March 17th 05 04:05 PM
troubles with ActiveWorkbook.Save Gabriele C[_4_] Excel Programming 1 August 11th 04 05:35 PM
protect module and work in activeworkbook Mark[_17_] Excel Programming 3 September 28th 03 10:43 PM


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"