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.
Cheryl B. wrote:
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?
--
Dave Peterson
|