CODEWITHSUNDEEP
vbaexcel
Sunaina
Sunaina

Reputation: 67

Hiding the data in rows -Excel VBA

I have three rows.I want to hide the data in those rows and display those rows in different color.I tried searching but only found Entirerow.hidden,which hides the row number as well. Is it possible to only hide the data in the rows and display it using some other color?

Upvotes: 0

Views: 83

Answers (1)

Sixthsense
Sixthsense

Reputation: 1975

The below code will change the background color to Yellow for rows 1 to 3.

Sub ChangeBackColorForSpecificRows()
    Rows("1:3").Interior.Color = 65535
End Sub

Change the Rows and Interior Color to suit your requirement.

Edit:-

formupahidden set to true not working neither formatting it to locked and hidden ,is hiding the content of formula bar – Sunaina

Copy the below code and do right click on sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(Target, Rows("1:3")) Is Nothing Then
    If Application.DisplayFormulaBar Then Application.DisplayFormulaBar = False
Else
    If Not Application.DisplayFormulaBar Then Application.DisplayFormulaBar = True
End If

End Sub

Upvotes: 1

Related Questions