Just a quick question out of curiosity..
I have a fairly complex Workbook with UserForms and formulas. We use it at work for automated data collection. I have all the sheets set to be xlVeryHidden and password protection on my code, etc. Anyway, we have this guy at work that knows a little about excel and he uses a password erase macro every shift and goes into the sheets and changes stuff around. He hasn't edited the code, so I don't think he is getting into the actual VBA part. What I'm curious to know is, say I have a sheet called October and it's xlVeryHidden. Is it possible to have an email sent to me without using Outlook and without him knowing if he does his little trickery and messes with the book and unhides October? If it's possible to get any extra information, such as time, his username or PC name, etc, that would be great, but since he works midnight shift and is the only person on site, it would be very easy to narrow it down based on the timing.
Thanks ahead of time...
Bookmarks