Determining if Other Workbooks Are Open
Harald,
Your post was not visible to me when I posted, so while it appears I was
contradicting you in a rather rude fashion, that is certainly not what I
was doing. I was just explaining to the OP why I had such a verbose
response.
Best Regards,
Tom Ogilvy
"Harald Staff" wrote in message
...
"Tom Ogilvy" skrev i melding
...
Since a user might have personal.xls or other hidden workbooks, you
can't
just check workbooks.count.
Good point. I never use that one myself, so it's not on my radar.
Otoh, I often open xla files, edit them and forget wether I saved them or
not.
Best wishes Harald
|