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,