test for new, unsaved workbook
Thanks Norman.
--
Doug
"Norman Jones" wrote in message
...
Hi Doug,
Your If ActiveWorkbook path = "" then test is fine.
---
Regards,
Norman
"Doug Glancy" wrote in message
...
I want to test whether a workbook is a brand-new/never-been-saved, i.e.,
"Book 1." I notice that such books do not have a path yet. Is that a
good test? E.g.,
If ActiveWorkbook path = "" then
' it's never-been-saved
Doug
|