+ Reply to Thread
Results 1 to 2 of 2

Sheet Protecting password

  1. #1
    Nick
    Guest

    Sheet Protecting password

    I have written some code to password protect a sheet when a button is
    pressed. Was hoping that someone could tell me is the same possible for the
    sheet button. So when the sheet2 button (bottom left corner of screen) is
    pressed a password is needed before access to the sheet is granted

  2. #2
    Dave Peterson
    Guest

    Re: Sheet Protecting password

    I don't think you could rely on it working.

    I'd have to use macros and if macros/events were disabled, then my code wouldn't
    even run.

    On top of that worksheet protection is very weak. It can be broken very
    easily. If you have sensitive data, don't put it in an excel workbook that will
    be shared with others.

    Nick wrote:
    >
    > I have written some code to password protect a sheet when a button is
    > pressed. Was hoping that someone could tell me is the same possible for the
    > sheet button. So when the sheet2 button (bottom left corner of screen) is
    > pressed a password is needed before access to the sheet is granted


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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