How do I print via macro on a protected worksheet

[ghrek]

HI

I have a protected worksheet as I do not want people to put data in certain cells.

What I'm trying to do is set up a print macro but it will not let me print as it states the workbook is protected. Is there anyway I can print a certain area via macro without compromising unprotecting my book and everyone seeing the password.

Any ideas?

 

[Michael M]

You will need to include the unprotect into your print code......execute the code then reprotect the worksheet / workbook

 

[rollis13]

@Michael M, that means he will have to hard-code his password and I think that's what he wants to avoid.
Maybe he could also protect his Project to avoid showing the code.

 

[Michael M]

@rollis13
Correct, but as you mentioned, protecting the project will stop anyone from seeing the password....not really any other alternative...

 

[ghrek]

Sorry so you saying protect the project? How do you do that?

 

[rollis13]

VBA menu Tools / Options / Protection, this will 'hide' your macros. Be aware, if you forget this password it wouldn't be easy to retrieve.

 

[ghrek]

Many Thanks

 

[rollis13]

I'm glad I've been of some help.