+ Reply to Thread
Results 1 to 1 of 1

Need method to validate if user has rights to change cell contents

  1. #1
    Forum Contributor
    Join Date
    Plano, TX USA
    MS-Off Ver
    Excel 2013

    Need method to validate if user has rights to change cell contents

    Hi Everyone -

    I have a spreadsheet that I want everyone to be able to look at but only certain individuals can change the cell contents.

    I do a check when a user first opens the spreadsheet to see who the user is and then look up the user in a table to determine their rights, ex John Doe can VIEW, Mary Jane can EDIT.

    Option 1:
    I want to set up an trap that checks whether the user has EDIT rights, and if so, allow the change to the cell contents. If the user does not have EDIT rights, I will display a message telling the user that they do not have rights to edit the cell content.

    Do I need to check via Worksheet_SelectionChange after the fact or is there a way to make the check when a cell is first selected?

    Option 2:
    Make the spreadsheet read-only when first activated, then check if user has proper rights to EDIT. If so, then set the spreadsheet to Read/Write. This would seem to be the simpler way but I have no clue how to set it up other than protecting the speadsheet.

    Thanks in advance for any help!

    Last edited by stubbsj; 08-24-2012 at 06:18 PM. Reason: Add additional detail
    If I was able to help you, I would appreciate your reputation feedback by using the * icon in the lower left.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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