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

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.