I don't have an online workbook to test with right this minute, but you might
try doing a similar test, but checking the first 4 characters of the full
path to the workbook to see if they are http -- if so, you know it's on some
web page, then you could set the .Saved property to true?

As I said, untested, kind of spitballing here.

"sb1920alk" wrote:

For workbooks that are accessed only through a web page (like a custom
calculator) where there is no need to save changes, how can I skip clicking
No every time I close the page?

I've tried: If ThisWorkbook.ReadOnly Then ThisWorkbook.Saved = True

but it doesn't work when the file is online.

Thanks in advance,