turn off display dialogue when closing

[jakol]

i'm really new using excell (2000), maybe someone could help poor guy
i have a spreadsheet that i print everyday,when closing the excel
program the save display dialogue opens even with no changes made t
the document, i'm guessing that the table calculates, recalculate
every time i open it co'z i'm using "volatile formulas" ie: today(
etc.........my question is how to get rid of this save displa
dialogue, or maybe turn off save prompting is this possible? thank yo
so much n advance. :

 

[Guest]

Right-click the Excel LOGO near the file menu, select "View Code", then paste this code in
Private Sub Workbook_BeforeClose(Cancel As Boolean
Thisworkbook.Saved=tru
End Su


----- jakol > wrote: ----

i'm really new using excell (2000), maybe someone could help poor gu
i have a spreadsheet that i print everyday,when closing the excel
program the save display dialogue opens even with no changes made t
the document, i'm guessing that the table calculates, recalculate
every time i open it co'z i'm using "volatile formulas" ie: today(
etc.........my question is how to get rid of this save displa
dialogue, or maybe turn off save prompting is this possible? thank yo
so much n advance. :

 

[jakol]

Works like a charm...thank you so much, i wish i can learn VB too.