prompt save only when changes have been made

[LFKim2018]

whenever I close a workbook, even though no changes have been made, a message box prompt to save or not almost always appear.

I want the workbook to prompt only when there are changes made - and close right away when there are not (no prompt nor message box)..

thank you

 

[ZVI]

It's the result of volatile functions like TODAY, OFFSET etc.
Or even of references like A1:INDEX(...)
Those recalculate each time workbook is open, thus cells with such functions/referencing become dirty.
But you may save workbook as XLSM or XLSB with the below code in its ThisWorkbook module:

Private Sub Workbook_Open()
  Me.Saved = True
End Sub

 

[LFKim2018]

Mr. ZVI
thank you for your reply
let me please explain my workbook (with several macros) - it is a costing program wherein dimensions and quantities have to be entered to compute for the cost of a particular metal desking frame.
even though there was not a single data entered (just opening the workbook - then closing it) there always is a prompt for saving or not.. kinda irritating.
vba should determine if there was data entered before issuing a save - not save prompt .. otherwise the workbook should just close right away (because no data was entered)
hope you got this
many thanks

 

[ZVI]

Mr. ZVI
thank you for your reply
let me please explain my workbook (with several macros) - it is a costing program wherein dimensions and quantities have to be entered to compute for the cost of a particular metal desking frame.
even though there was not a single data entered (just opening the workbook - then closing it) there always is a prompt for saving or not.. kinda irritating.
vba should determine if there was data entered before issuing a save - not save prompt .. otherwise the workbook should just close right away (because no data was entered)
hope you got this
many thanks

Hi FKim,
The behavior of the issue is clear, thanks.
The code suggested in my previous post may solve it, have you tried it?
Regards

 

[LFKim2018]

Hi FKim,
The behavior of the issue is clear, thanks.
The code suggested in my previous post may solve it, have you tried it?
Regards

Mr ZVI
thank you for your reply.
I tried it but it isn't working.
can I send you the file for analysis?
How can I send it?
Thank you

 

[ZVI]

...
can I send you the file for analysis?
How can I send it?...

Hi LFKim,

I've sent you my email in Private Message (PM).
You may email me your file for analysis.

Regards

 

[LFKim2018]

Hi LFKim,

I've sent you my email in Private Message (PM).
You may email me your file for analysis.

Regards

Mr ZVI
so sorry I don't know where to find your PM
thank you

 

[ZVI]

Mr ZVI
so sorry I don't know where to find your PM
thank you

On very top line of this web page click on item Notifications and choose Unread Private Messages

 

[LFKim2018]

On very top line of this web page click on item Notifications and choose Unread Private Messages

Mr ZVI
I checked the 'notification' - there was no message.

thank you

 

[ZVI]

Please check PM once more.
I've sent you email as well.
But please do not post your email here as it is sensitive data.