Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2006
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Security (2003)

    I received an email from a user about setting up a shared Excel file. I've done all that...but her question went into something with Excel I had not ventured into. She wants to limit the tabs a user can view when in the file...different tabs for different users. My initial reaction was to build an Access database and create a form per user and go through security there...I wasn't sure if Excel could do what she wants. I have told her I am researching what she wants to do...any advice? Is this doable and if so, how???? I am not well versed in VBA, so if the solution lies there, I may need some help there [img]/forums/images/smilies/smile.gif[/img] I am learning it, but know enough to be really dangerous!! Thank you!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Security (2003)

    Welcome to Woody's Lounge!

    I am not a fan of shared workbooks. It is not really implemented well, and can easily lead to workbook corruption. And the problem with a VBA solution is that it falls flat if the user disables macros. I agree with you that an Access database with user-level security would be a much better solution.

  3. #3
    New Lounger
    Join Date
    Mar 2006
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Security (2003)

    Thanks a lot, Hans. I appreciate your feedback. Hope you have a terrific day!!!

    Take care!
    Kate

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •