Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Our daily spreadsheet template contains 10 printable pages. Each
page contains 5 rows of header information and 25 rows for data entry. (In other words, one page equals 30 rows). Users will typically fill up anywhere between 0-6 pages per day. Here's my problem: Whenever a user presses 'Print' (or even Ctrl-P), Excel will automatically print all 10 pages. This will often waste paper, because what if a user only fills up 2 pages with data? That means the remaining 8 empty pages get printed as well. So, if a user presses 'Print' or Ctrl-P, how can I tell Excel to only print the pages that contain data? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing from a control button | Excel Programming | |||
Printing Control | Excel Programming | |||
Get Control Before AND After Printing | Excel Programming | |||
Get Control Before AND After Printing | Excel Programming | |||
My spreadsheet has a control box. box moves after printing. Why? | Excel Discussion (Misc queries) |