To protect user's privacy

Discussion in 'Excel Programming' started by dghelardi@gmail.com, Apr 14, 2014.

  1. Guest

    I have a number of users that have to work on the same excel workbook.
    Each user should have access to its own worksheet and be denied to *see* other users data.
    I managed to selectively show and hide worksheets by a form asking for usn+pw in the ThisWorkbook.Workbook_Open() event.
    Now I want to deny a smart user to access other user's data by VBA commands in the immediate window, so I need to deny access to VB Editor.

    How can I temporary disable VB Editor?

    Thanks in advance,
    David
     
    , Apr 14, 2014
    #1
    1. Advertisements

  2. GS Guest

    > I have a number of users that have to work on the same excel
    > workbook. Each user should have access to its own worksheet and be
    > denied to *see* other users data. I managed to selectively show and
    > hide worksheets by a form asking for usn+pw in the
    > ThisWorkbook.Workbook_Open() event. Now I want to deny a smart user
    > to access other user's data by VBA commands in the immediate window,
    > so I need to deny access to VB Editor.
    >
    > How can I temporary disable VB Editor?
    >
    > Thanks in advance,
    > David



    To disable access to the VBE requires disabling several keys and menus.
    It might be wiser to use Environ("username") as a safety mechanism so
    only the logged in user can access their worksheet. Require a password
    to make sheets visible, where the password must match the username.

    --
    Garry

    Free usenet access at http://www.eternal-september.org
    Classic VB Users Regroup!
    comp.lang.basic.visual.misc
    microsoft.public.vb.general.discussion
     
    GS, Apr 14, 2014
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. wijwoj
    Replies:
    0
    Views:
    101
    wijwoj
    Oct 30, 2003
  2. hotherps

    Protect sheets w/o user password prompt

    hotherps, Nov 24, 2004, in forum: Excel Programming
    Replies:
    6
    Views:
    132
    Paul B
    Nov 24, 2004
  3. Replies:
    5
    Views:
    213
    Dave Peterson
    Aug 9, 2005
  4. Souris

    Protect spreadshet, but allow user edit range

    Souris, Aug 21, 2005, in forum: Excel Programming
    Replies:
    2
    Views:
    153
    Souris
    Aug 22, 2005
  5. Paul Moles

    Disable Tools, Protect, Protect Workbook

    Paul Moles, Sep 5, 2005, in forum: Excel Programming
    Replies:
    1
    Views:
    121
    Ron de Bruin
    Sep 5, 2005
  6. Desert Piranha

    Protect UserInterface VS Protect/Unprotect

    Desert Piranha, Jan 31, 2006, in forum: Excel Programming
    Replies:
    2
    Views:
    179
    Desert Piranha
    Feb 1, 2006
  7. Kermitp
    Replies:
    2
    Views:
    90
    Kermitp
    Apr 24, 2008
  8. Sören_Marodören

    Privacy warning in Excel 2007

    Sören_Marodören, Apr 2, 2009, in forum: Excel Programming
    Replies:
    1
    Views:
    117
    Dr3Bob
    Apr 2, 2009
Loading...