Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is It Possable to....
What I would like to do is...have a group of cells and there functions not
seen on worksheet But when you check a box or enter yes in a box on that worksheet they will then appear on the work sheet I hope that you can understand my "Q" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is It Possable to....
Hi,
You need to be more specific. To hide the formulas in the formula bar then you could format the cell(s) as hidden, protect the sheet and the formulas don't appear in the formula bar. To physically hide the rows or columns so the cells (seems to) disappear depending on the value of the cell then this can be done with a macro. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then If Target.Value = "Y" Then Rows("10:16").EntireRow.Hidden = True Else Rows("10:16").EntireRow.Hidden = False End If End If End Sub This hides rows 10 to 16 if a capital Y is put in A1 and unhides then if any other value is entered.. Right click the sheet tab , view code and paste this in. Mike Mike "KG121953" wrote: What I would like to do is...have a group of cells and there functions not seen on worksheet But when you check a box or enter yes in a box on that worksheet they will then appear on the work sheet I hope that you can understand my "Q" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is It Possable to....
THANK YOU!!!! That is what I wanted
(It took me a few tries to make it work for my situation but I did it thanks to you) "Mike H" wrote: Hi, You need to be more specific. To hide the formulas in the formula bar then you could format the cell(s) as hidden, protect the sheet and the formulas don't appear in the formula bar. To physically hide the rows or columns so the cells (seems to) disappear depending on the value of the cell then this can be done with a macro. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then If Target.Value = "Y" Then Rows("10:16").EntireRow.Hidden = True Else Rows("10:16").EntireRow.Hidden = False End If End If End Sub This hides rows 10 to 16 if a capital Y is put in A1 and unhides then if any other value is entered.. Right click the sheet tab , view code and paste this in. Mike Mike "KG121953" wrote: What I would like to do is...have a group of cells and there functions not seen on worksheet But when you check a box or enter yes in a box on that worksheet they will then appear on the work sheet I hope that you can understand my "Q" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possable to run an macro or script at start up as you could | Excel Worksheet Functions | |||
Is it possable? | Excel Worksheet Functions |