Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Macro to print a sheet conatining drop down menu
Hi,
I got a worksheet with drop down menu containg 10 items in the drop down and other information connected to database. i want to print each item from the drop down menu. so i don't want to choose each item every time and then print. so in normal case i have to select each item and then click on print.so i have to do this 10 times. all i want to do is with one click it should select automatically from the drop down menu and print. but i have tried recording the macro but is not working.it is selecting active sheet and what ever the item is active in the drop down it prints q0 times. so i need someone who can write a macro that can choose the second item, third item and so on and print them indivdually. any info related to the query is highly appreciated. Thanks in advance. Faizal Cassim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you print drop down menu | Excel Discussion (Misc queries) | |||
updating sheet by choice from drop down menu | Excel Discussion (Misc queries) | |||
Macro Drop Down Menu | Excel Discussion (Misc queries) | |||
how to activate a drop down menu in spreed sheet with space bar? | Excel Discussion (Misc queries) | |||
Is there a way to ReName a Sheet Using a Drop Down Menu? | Excel Programming |