The saved property will be reset if you have any volatile functions in
your sheet (e.g., NOW(), TODAY(), RAND(), AREAS(), CELL(), COLUMNS(),
INDEX(), INDIRECT(), OFFSET(), ROWS()), prompting the "Do you want to
save" dialog.



In article ,
"Hari" wrote:

1. I have a file in which I have workbook_Open event in which I hide some
sheets and unhide some sheets

I have my macro security set to medium. When I open this workbook I get a
message for enabling or disabling macros.

I chose disabling macros and open the file.

I dont do any changes and close the file as it is, but Excel asks me whether
I want to save my changes or not. Why is this happening. When neither myself
nor the workbook_open event has operated why should excel ask me for saving
changes or not? (JFYI, I have a workbook_close event also in this workbook
but when macros havent been enabled then I believe that shouldnt affect the
workbook anyway..)