Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
InputBox to get user hidden columns question
Can I develop this further to hide columns before printing,
or is there a better way, please? Dim ExclColRng As Variant Set ExclColRng = Application.InputBox("Use the left mouse " & _ "button with the Control key," & vbNewLine & "to select at least" _ & " one cell in each column " & vbNewLine & "(or the entire" _ & ".column), to indicate those" & vbNewLine & "Columns to be" _ & " hidden. Click OK. when done", Type:=8) This seems to take the user's hidden columns into the inputbox, but can I use this, and if so how, please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.505 / Virus Database: 302 - Release Date: 30/07/2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox / VBA question ok = print, cancel = exit | Excel Worksheet Functions | |||
Another InputBox question... | Excel Discussion (Misc queries) | |||
Prevent User Seeing Data in Hidden Columns | Excel Discussion (Misc queries) | |||
inputbox question | Excel Discussion (Misc queries) | |||
String length of Inputbox user input. | Excel Programming |