Quote:
"1. I'm not sure I understand "Force macros to run, by hiding all
sheets..."
- Here when a workbook is opened, only one sheet is available, because
before saving, a macro forced all other to be VeryHidden. The only way
to unhide is to enable macros.
"2. Looking at the code, I don't think that VBA knows what to do with
the
word 'Now'"
It actually does know what to do with Now, that is one of the codes that
actually works!

The part of the code that I think that doesn't work, is the part where I
try to loop through all sheets to determine which ones are hidden, and
which ones aren't.

may i ask if someone again, could quote my code as I have posted it, and
add there own comments in between the code to tell me where the
potential problems could be?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!