+ Reply to Thread
Results 1 to 4 of 4

User access

  1. #1
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    409

    User access

    Hi I have a column (E) that I would like only certain users to be able to adjust the value of (it has a drop down box in it). I was thinking it could look at the username of the computer and then allow access if it matches a set of usernames. I'd prefer it not to be a macro if possible.

    Many thanks
    Dave

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: User access

    It will have to be a macro... Formulas cannot modify the protection/lock status of cells.

  3. #3
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    409

    Re: User access

    Ok thanks I thought so, can anyone create a macro please.

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: User access

    Lots of different ways. Probably the simplest is :
    • Use the Worksheet_Change event.
    • Check the cell(s) changed are in the range.
    • Check the Environment variable 'USER' in in the list of users allowed to edit.
    • Undo the changes if not.


    All very basic stuff... Why not try it? There's a comprehensive description here

+ 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. Replies: 1
    Last Post: 05-27-2015, 01:31 PM
  2. Access user
    By sharon23 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-10-2013, 07:44 PM
  3. How To run Access database without having to install Access on user PC's
    By Reema in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2009, 04:02 AM
  4. Can Multi User Access be possible
    By L_ter in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-25-2009, 06:05 AM
  5. User Access
    By Sarah247 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-13-2006, 07:39 AM
  6. [SOLVED] Last Access User
    By SaintCheap in forum Excel General
    Replies: 3
    Last Post: 01-19-2005, 06:06 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