I understand your problem, but I still don't see why the workbook
needs to be shared, if all they are doing is looking at the worksheet.

What do you mean by "logging on" and how do you tell who is who?

If the data is that sensitive, why not break it out into separate
workbooks? Maybe a re-think of the design is in order. Or store the
data in an Access table, and write some Excel code to conditionally
query the mdb for the necessary data, depending on the requestor?

--JP


On Oct 23, 12:35*pm, ryguy7272
wrote:
Thanks for the comment JP. *Yes, it has to be shared, as a couple dozen
people are logging in to the workbook to check the status of some sales
stuff. *Yes, we need the macros to control which sheets are displayed when
each user logs in (well, when it works correctly...). *I think this project
would have been much better suited for Access, but virtually no one here has
Access on their computers, except me, and virtually no one here knows how to
use Access, except me.

Any other comments, suggestions, etc.

Thanks,
Ryan-- *

--
RyGuy