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

    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

Ask a Question

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.