Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a print menue
Hi all,
I'm working on a winxp/xl2000 system and I want to have a print menue for my two sheets in the file so on the first sheet I've got the month 1st sheet: Jan-Febr-Mrz-April-Mai-Jun (seperatly one DIN A4 paper for each month) 2nd sheet: Jul-Aug-Sept-Okt-Nov-Dez (seperatly one DIN A4 paper for each month) completely twelfe papers for the whole year. now I want to've a litle menue where I can choose which month I want to print separately. --------------------------------------------------------- PRINT-MENUE [ ] press this button for JANUARY-sheet [ ] press this button for FEBRUARY-sheet [ ] press this button for MARCH-sheet ..... and so on [ ] press this button for all sheets --------------------------------------------------------- The print process can start bei choosing the option. If you've any idea .. thanks for this :-) greetings achim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a print menue
Possibly you can adapt this code by John Walkenbach to do what you want:
http://www.j-walk.com/ss/excel/tips/tip48.htm -- Regards, Tom Ogilvy "Jamen_Hannover" wrote in message ... Hi all, I'm working on a winxp/xl2000 system and I want to have a print menue for my two sheets in the file so on the first sheet I've got the month 1st sheet: Jan-Febr-Mrz-April-Mai-Jun (seperatly one DIN A4 paper for each month) 2nd sheet: Jul-Aug-Sept-Okt-Nov-Dez (seperatly one DIN A4 paper for each month) completely twelfe papers for the whole year. now I want to've a litle menue where I can choose which month I want to print separately. --------------------------------------------------------- PRINT-MENUE [ ] press this button for JANUARY-sheet [ ] press this button for FEBRUARY-sheet [ ] press this button for MARCH-sheet .... and so on [ ] press this button for all sheets --------------------------------------------------------- The print process can start bei choosing the option. If you've any idea .. thanks for this :-) greetings achim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vb drop down menue | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
How to create a menue bar of numbers in a cell? | Excel Worksheet Functions | |||
Menue | Excel Programming | |||
Create a print macro that would automatically select print area? | Excel Worksheet Functions |