Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default Can I protect the page setup? i.e. 45% landscape

I'm using Excel 2003. I want to protect my document so that no one can
change the printing options. It won't print correctly if it is not set at
45% landscape.
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default Can I protect the page setup? i.e. 45% landscape

I haven't been able to.

Maybe you could provide a macro that prints with the exact settings you want.

Or put some code into the workbook_beforeprint that puts stuff back the way you
like.

But if the user disables macros (or events), then this won't work.

obliro wrote:

I'm using Excel 2003. I want to protect my document so that no one can
change the printing options. It won't print correctly if it is not set at
45% landscape.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
not getting landscape in page setup? Yellapragada Setting up and Configuration of Excel 1 November 1st 06 11:04 AM
I can't get page to display/print as landscape, have done setup Al Excel Discussion (Misc queries) 1 February 17th 06 05:13 PM
I would like page setup to always be in landscape not portrait Tom Excel Worksheet Functions 0 December 13th 05 12:27 AM
Page Setup - landscape and portrait MLRB Setting up and Configuration of Excel 3 October 29th 05 07:43 PM
protect format - page setup kva Excel Discussion (Misc queries) 1 February 17th 05 03:06 AM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"