ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   wb.Saved + CustomDocumentProperies problem (https://www.excelbanter.com/excel-programming/368227-wb-saved-customdocumentproperies-problem.html)

karnek[_4_]

wb.Saved + CustomDocumentProperies problem
 

Hello,

I implemented the "workbookBeforeSave" event where I want to replace
the saving process. When user don't wants to save workbook I call
"wb.saved" and "application.quit". But here I have problem because when
I store new CustomDocumentProperies before the saving then
"application.quit" ask me again than If I want save the workbook. And
that is wrong!

Could you help me with this issue, please?

Karol Nekanovic


--
karnek
------------------------------------------------------------------------
karnek's Profile: http://www.excelforum.com/member.php...o&userid=36570
View this thread: http://www.excelforum.com/showthread...hreadid=564602


R..VENKATARAMAN

wb.Saved + CustomDocumentProperies problem
 
did you try to put a line at the begining
application.displayalerts=false
and at the end
application.displayalerts=true.

the last line is necessary

========================
"karnek" wrote in
message ...

Hello,

I implemented the "workbookBeforeSave" event where I want to replace
the saving process. When user don't wants to save workbook I call
"wb.saved" and "application.quit". But here I have problem because when
I store new CustomDocumentProperies before the saving then
"application.quit" ask me again than If I want save the workbook. And
that is wrong!

Could you help me with this issue, please?

Karol Nekanovic


--
karnek
------------------------------------------------------------------------
karnek's Profile:
http://www.excelforum.com/member.php...o&userid=36570
View this thread: http://www.excelforum.com/showthread...hreadid=564602





All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com