I'm trying to create VBA code in Excel to do 2 things:
1) Hide a range of cells then password protect the sheet so that only
certain users (with the passwod) may view the hidden data.
2) When the users open up the workbook, unprotect the sheet by asking
the user for the password. When the correct password is input,
unprotect and unhide the above data.

My primary problem is that whe I try to record the macro, it ignores
anything to do with password protection. I can automate the protection
and unhiding of data, however I can't get it to password protect...nor
can I get it to ask for a password to unprotect.

Thanks in advance



*** Sent via Developersdex http://www.developersdex.com ***