Macro that retains password.

S

SpeeD72

Hi guys.

Im doing a macro that hides some rows and then protects a
sheet (sheet1). What i cant do is to retain the original
password protection for that sheet. I can´t make excell
ask me for a password either.

If this can´t be done, can i hide some rows and protect
them with a password so that nobady can unhide them??

Thanks a lot!!!
SpeeD
 
T

Thomas

'hide your rows
activesheet.protect "Your password"
'to unprotect sheet
activesheet.unprotect "Your password"
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting Word 2019 document 0
macros to hide sheet with protection 1
Password for running Macro 2
password protect individual sheets 1
Command button wz 2 function 1
How to Store Passwords To Multiple Sheets and To Retain thatPasswords When the Workbook IS closed 1
prompt password for a worksheet 5
Prevent User from Changing Password 2

Top