Excel Macro Help

Closed
Enisea - Oct 9, 2009 at 12:14 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 13, 2009 at 06:20 AM
Hello,

I am looking for a way to password protect certain worksheets from viewing.

I have sales totals in one sheet and sales commissions in another. I want the "commissions" sheet to be password protected so that if anyone clicks on the bottom tab they will be prompted for a password.

Does anyone know if this requires VBA?
Related:

2 responses

Blocked Profile
Oct 13, 2009 at 05:05 AM
Dear Sir,

This is an easy thing to do. Get on the tools selecting options. You will

easily see a security settings. You will have to enter the password you

want over there.

Thank you.
0
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 13, 2009 at 06:20 AM
Hello there,
Press ALT+F11 to goto VB Editor
select your sheet and then for its properties "visible" make it to xlsheetveryhidden
then password protect your VBA going to Tools>>VBA project properties>> Protection
0