Can I create a workbook that limits the sheets that are shown after logon?
I am setting up macros to create hundreds of sheets in groups of threes.
This will eventually all my automated. But, each manager needs to only view
their data for legal reasons. There are other ways of getting this
information within the company, but the legal team would like for me to limit
access when I can.
I have never tried to password protect a document for around a hundred users
and their corresponding passwords and then only show them their three sheets
of data.
Any suggestions on where to start?
Bookmarks