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

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