+ Reply to Thread
Results 1 to 2 of 2

Excel multi user email specific row restriction

  1. #1
    Registered User
    Join Date
    02-26-2021
    Location
    Singapore
    MS-Off Ver
    365
    Posts
    1

    Excel multi user email specific row restriction

    I have an excel file that has multiple rows dedicated to multiple users. I also have 3 master users that need to be able to live edit the file. How do I restrict the lower level users to their own rows while letting the master users have live access to the document.

  2. #2
    Registered User
    Join Date
    12-22-2014
    Location
    Netherlands
    MS-Off Ver
    O365
    Posts
    58

    Re: Excel multi user email specific row restriction

    Best way to set it up I guess;

    Protect one sheet with password for the "masters"
    Use an unprotected worksheet for all the other people, reference the unprotected to the master.
    that way they can only alter, what you reference!

    greetings

+ 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. [SOLVED] Send email to specific people in Range depending on result from user in an InputBox?
    By Doolski in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-16-2016, 03:16 PM
  2. Command Button that allows user to email and print specific sheet
    By KT99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2014, 11:06 AM
  3. [SOLVED] Restriction to modify the range by single user alone
    By Naresh27 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2013, 03:17 PM
  4. [SOLVED] email selected cells with restriction
    By talochka in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-27-2013, 12:17 PM
  5. Use excel VBA to create a multi-rowed email
    By jonjmortimer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2013, 09:33 AM
  6. [SOLVED] Multi-user access to Excel
    By Bob in forum Excel General
    Replies: 7
    Last Post: 07-09-2012, 10:30 PM
  7. User restriction
    By Bob@Sun in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-06-2010, 02:55 PM

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