| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Printing of worksheet
Hello... I have 2 worksheets that I need to print out based on a cell value in a third worksheet written as a macro. Example of sheets named: Sheet1, Sheet2, Sheet3. Sheet1 contains the control variable in Cell A55. If a value of 1 is in cell A55, then I wish to print only Sheet1 when the macro is run. If a value of 2 is in this cell, then I wish to print both Sheet1 and Sheet2 when the macro is run. Simple? Maybe for the VB'ers. Any idea?? Thanx as always. Thor. -- Thor ------------------------------------------------------------------------ Thor's Profile: http://www.excelforum.com/member.php...fo&userid=1049 View this thread: http://www.excelforum.com/showthread...hreadid=500474 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional printing | Excel Discussion (Misc queries) | |||
| Conditional Printing | Excel Discussion (Misc queries) | |||
| Conditional Printing | Excel Programming | |||
| conditional printing | Excel Programming | |||
| conditional printing | Excel Programming | |||
![Thor[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
