Looking for the Code for my Macro to unprotect my work sheets

[Inez15]

I have an excel that has Marco being run by using a command button to create my pdf's. But my work sheets are Protected by a password. Is there a code for me to insert in order for the worksheet become unprotected for it to do the commands I am requesting?

Thank you -

[protonLeah]

don't you know the password?

[Inez15]

Yes I know the password. My workbook is Protected, and when the end users get the workbook they are to click the command button that has a macro built in for it to save the book in a specific folder and generate pdf reports. Will my macro is set up to delete blank lines and it will not work if the sheets are protected. So I am looking for a code that would unprotect the sheet first, for it then to delete the blank lines, then create the pdf reports.

I think the code would be this...

Please Login or Register  to view this content.

But I'm not sure since I am having issue now with my code to delete the lines.

Thank you....

[6StringJazzer]

That works. You don't have to unprotect at the workbook level. I would recommend you use the actual sheet name instead of ActiveSheet. And don't forget to re-protect:

Please Login or Register  to view this content.

By the way, if you put a password into your code, now you should password-protect the code.

[Inez15]

Reply good idea in protecting the code - how would password protect the code?
Thank you for the correct code to allow my workbook to function better.

[Inez15]

Figured out how to protect my code.
In the VB editing window, under Tool select VBAProject Properties, select protect tab.