Hello everyone!

I have an Excel document with some worksheet functions that cause the dirty
flag to be set, so I've been looking for a way to clear the dirty flag as
soon as the document is opened (in order to avoid being asked to save the
document when it is only opened and closed, without having made any
changes).

Now, I know that it is possible to achieve this by putting code in a macro
for THAT PARTICULAR document, but since this triggers a question (about the
macro) to pop up every time the document is opened, and that is not an
option for me.

So, what I want to be able to do is put that very same code (that clears the
dirty flag when the document is opened) in the Personal.xls file and have it
work FOR ALL documents that are opened. I've been trying with code such as:

ThisWorkbook.Saved = True
Application.ThisWorkbook.Saved = True
Workbooks(1).Saved = True
ActiveWorkbook.Saved = True

Dim myworkbook As Object
Set myworkbook = Excel.Application.ActiveWorkbook
myworkbook.Saved = True

But none of these approaches have worked. It seems as though Excel can't
find/access the newly opened document from the code in the Personal.xls
file... Or at least, _I_ have not been able to achieve this. Could anyone
help me?

Thanks in advance!
/Carl