turn off display dialogue when closing

  • Thread starter Thread starter jakol
  • Start date Start date
J

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.:( :( :
 
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.:( :( :
 
Back
Top