+ Reply to Thread
Results 1 to 3 of 3

Open Log in Form When Click anyware in the Sheet

  1. #1
    Registered User
    Join Date
    07-27-2014
    Location
    Saudi Arebia
    MS-Off Ver
    Microsoft 10
    Posts
    56

    Open Log in Form When Click anyware in the Sheet

    Dear All,
    I seek your assistance to solve my Douts
    I have on Excel file for NQC.there have 3 sheet. i want lock main sheet with login form .for user and Admin,
    For user just access for read .not allow to edit or do anything in that sheet
    For admin have access for do everything in that sheet .

    Please help me to do it

    thanks for your ccoperation
    Br,
    Nisar.mohammed
    Attached Files Attached Files

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Open Log in Form When Click anyware in the Sheet

    Your workbook has no userform.... are you asking us to make the form and all the code? or do you have a sheet with some work already?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    07-27-2014
    Location
    Saudi Arebia
    MS-Off Ver
    Microsoft 10
    Posts
    56

    Re: Open Log in Form When Click anyware in the Sheet

    Dear Friend i can create userform and Code for Log But i dont know how i can provide access for read only for other user
    If i am The admin i have Access to Edit, save , delete but other user have access for read

+ 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. How to open a form No.2 from the combined values of 2 combo boxes from sheet 1 ?
    By Harmeet Singh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2013, 03:07 AM
  2. Populate Excel Userform with Sheet names with double click to open the sheet ??
    By Shacker in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-08-2013, 03:54 PM
  3. macro to open sheet upon click
    By Jordans121 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-25-2011, 03:22 PM
  4. Copy/Paste special form one sheet to another into first open colum
    By GeorgeD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2010, 05:50 PM
  5. Copy my active sheet to a new sheet and open with an input form
    By Brad Withrow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2006, 11:00 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