LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 133
Default Page Setup protection

How can I keep someone out of the "File Print" area on a protected
workbook/worksheet? The only cells accessible are the ones that I want used
for data entry, and I've set the print range to the cells that I want
printed, but it all falls apart when I (or some nefarious soul) wander into
the "File / Print" area. I can clear the print range, set a new print range,
add headers and footers...generally make a mess of things. How can I keep
people locked out of this area and force them to use the Print Icon to print
only the range that I've pre-selected? I've protected the Sheet AND the
Workbook, but it doesn't look too protected to me. It has to be bulletproof.
 
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
Excel Page Setup Reflective Eye Excel Discussion (Misc queries) 3 June 24th 06 01:38 AM
Page Setup changes Loris Excel Discussion (Misc queries) 0 March 7th 06 03:57 AM
Page Numbers Aurora Excel Discussion (Misc queries) 0 November 17th 05 08:04 PM
Macro to automate page protection based on combo box reply wongard Excel Discussion (Misc queries) 9 September 9th 05 06:47 AM
How do I copy page setup from one worksheet & paste into new shee. Rasc0 Excel Discussion (Misc queries) 2 December 1st 04 10:12 PM


All times are GMT +1. The time now is 11:13 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"