View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Charlotte E.[_3_] Charlotte E.[_3_] is offline
external usenet poster
 
Posts: 160
Default ThisWorkbook.Saved = True

Found a solution myself :-)

Thanks for your effort anyway, guys :-)

CE


Den 24.08.2012 11:31, Charlotte E. skrev:
Hi

I have a workbook, which perform some macro-actions when opened.

As the VERY LAST LINE in both 'Workbook_Ope'n and 'Workbook_Activate', I
have:

ThisWorkbook.Saved = True


....and yet, if I open the workbook, at immediatly close the workbook,
it asks me, if I want to save the changes, even that I haven't made a
single change?!?

It is as if the 'ThisWorkbook.Saved = True' has no effect???

What am I missing?


CE