Looking at the protect options, one of the options was about pivot tables, which reminds me...
Some years ago the Personel guy circulated a workbook with salary summaries for us managers to use @ raise time. I don't recall just what was on the accessable sheet, but it was not salaries, but something like statistics.
Well, I happened to accidently double click on something - I think it may have been a pivot table, or something with a pivot table as it's source (there was a pivot table involved) - and I was popped to the source data which was all the individual salary data, for the whole business center.
It must have only been hidden - a real oops.
I don't think I ever told him...I wonder if I kept that workbook...? (retired now)
Steve
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar