+ Reply to Thread
Results 1 to 2 of 2

Can I set up controls in a worksheet for multiple users to access only their information?

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Fairbury NE
    MS-Off Ver
    Excel 2007
    Posts
    70

    Can I set up controls in a worksheet for multiple users to access only their information?

    I have a worksheet (database) that is currently being used by one department to generate shipping forms and it works great. Each shipping form has a unique number for reference.

    I'm looking for the best way to track the shipping process after the form has been generated (i.e., date product was shipped, initials of person who shipped) through either adding a column or worksheet for the "shipping department" to enter the data into showing. Any suggestions?

    Thanks.
    Last edited by maryren; 09-05-2013 at 10:13 AM.

  2. #2
    Registered User
    Join Date
    06-12-2013
    Location
    Fairbury NE
    MS-Off Ver
    Excel 2007
    Posts
    70

    Re: Can I set up controls in a worksheet for multiple users to access only their informati

    I resolved this on my own. I used the "protect" feature under the "Review" tab on the top ribbon (Allow Users to Edit Ranges). Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Access to workbook by multiple users
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2012, 04:54 AM
  2. How to control multiple users access one excel spreadsheet?
    By adds007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2010, 11:04 AM
  3. Allow multiple users to get access to excel application
    By Nancy123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2010, 07:23 AM
  4. limited access for multiple users
    By sendtobrad in forum Excel General
    Replies: 0
    Last Post: 01-08-2010, 08:52 PM
  5. Deploying Access Table for Multiple Users
    By crazysniper in forum Access Tables & Databases
    Replies: 0
    Last Post: 11-02-2009, 09:16 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1