Hi

I have an excel sheet. I have locked this excel sheet using the macros. most of the features of excel sheet such as hide/unhide rows, sheets, cut, copy and paste are locked by default (whenever user opens the spreadsheet).

I want to get help with a macro that can assist me to do the following:

1) On running - first step to unlock the sheet (I have the password).
2) Hide rows where in column K (from column K1 to K1000 only) - the value is "Draft sent".
3) Now, lock the sheet again.

Thanks

Regards