View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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