Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invisible cells in VBA
I want to make a range of cells on one of my worksheets invisible to the
viewer although the data in the cells will still be availble to the code. I have selected the range but don't know the property or method for making the cells invisible. I tried " .Visible = False" on the selection but I got an error message. Thanks for any help, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invisible cells in VBA
You can't make individual cells "invisible." You can hide entire rows or
entire columns. -- Vasant "Ian" wrote in message ... I want to make a range of cells on one of my worksheets invisible to the viewer although the data in the cells will still be availble to the code. I have selected the range but don't know the property or method for making the cells invisible. I tried " .Visible = False" on the selection but I got an error message. Thanks for any help, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Invisible cells in VBA
if you don't want to hide the rows then you could simple format the row to
";;;" They will appear empty but seelcting the cells will still reveal their values. Why not just put the data onto another sheet? "Ian" wrote: I want to make a range of cells on one of my worksheets invisible to the viewer although the data in the cells will still be availble to the code. I have selected the range but don't know the property or method for making the cells invisible. I tried " .Visible = False" on the selection but I got an error message. Thanks for any help, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text is invisible | Excel Discussion (Misc queries) | |||
Format cells to make zeros not appear,or be invisible on screen &p | Excel Discussion (Misc queries) | |||
Invisible Formatting ? or ... ? | Excel Worksheet Functions | |||
Selected cells shadding Invisible. | Excel Worksheet Functions | |||
Validation List with Variable Lengths & Invisible Empty Cells | Excel Programming |