Sharing: How can one share a workbook with 6 worksheets to 3

  • Hi maluodo,

    You could create a workbook_open event macro that asks for a username & password, then applies the "xlveryhidden" property to the worksheets not associated with that user. If you are using the "Share Workbook" feature in Excel, however, I've heard that VBA routines sometimes don't act right with sharing.

    Another possibility, which may be easier, would be to have 3 individual workbooks for the 3 users, then create a 4th workbook (password protected) to consolidate the 3 sheets using links.

    Post back with some more details if this doesn't do it.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!