Chaning Print Settings in Password Protected File

C

Cheryl B.

While the data is very good, the 'publisher' didn't put much thought and/or
effort into what it looks like in printed form ...

Is there a way to modify 'page setup' parameters for an Excel file that is
password protected?
 
D

dominicb

Good evening Cheryl B

Only by unprotecting the worksheet, changing the print settings and
then reprotecting the sheet again. if you don't have the password,
look here for how to do it without the password:

http://www.mcgimpsey.com/excel/removepwords.html

If you're unfamiliar with VBA and putting this code into a module I
have an add-in available, free of charge to anyone who e-mails me which
will do a similar thing, amongst other general Excel tasks.

HTH

DominicB
[email protected]
 
D

Dave Peterson

What kind of protection stops you from changing the page setup?

And what specific item is can't you change?

I could change the page setup if my worksheet were protected
(tools|protection|protect sheet) or if the workbook was protected
(tools|protection|protect workbook).

If the workbook was protected from opening and I didn't know the password, then
(obviously) I couldn't change it.

If the workbook was protected from updates (readonly), then you could turn that
off, and do the changes.

File|SaveAs|Tools|General Options
Remove the password to modify
Then save it as a new name.
Delete the old version
Make your changes
add the password to modify back
save as the old name.
 
Top