Consulting

Results 1 to 2 of 2

Thread: Multiple users

  1. #1
    VBAX Expert
    Joined
    Apr 2007
    Location
    Orlando, FL
    Posts
    751
    Location

    Multiple users

    Is it possible to do this.
    I want to create a spreadsheet with three (3) or four (4) worksheets.
    Each work sheet would have a different Form.
    But I want to know If I can have multiple users using this spreadsheet at the same time?

    If So Can I have a security type of login. So if User1 logs in he can only see sheet1.
    If User2 logs in He can only see Sheet2.
    If User 5 logs in He can see both Sheet1 and Sheet2.

    This is a lot. I hope someone can help or point me into the right direction.

  2. #2
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    While theoretically possible with a Shared Workbook, I would stay very, very clear of them. They have way too many limitations, and are far too prone to problems for my liking.

    The situation you describe sounds, on the surface, like why databases were invented. This may not be the words you want to hear, but the "right direction" is to start looking at Access or another database platform.
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





Posting Permissions

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