Hide Confidentiality row with vba code when excel is opened

[Raffe123]

Hello all,

Can I will vba code hide the confidentiality row when excel is opened?

/R

 

[ashakantasharma]

You can try and customize the below VBA Code as per requirement and see it it works in your case.

Sub sbHidingUnHideRows()

'To Hide Rows 22 to 25
Rows("5:8").EntireRow.Hidden = True

'To UnHide Rows 22 to 25
Rows("5:8").EntireRow.Hidden = False

End Sub

 

[Michael M]

@Raffe123
Keep in mind though that if someone disables macros on the workbook, no macro will hade a row !!
And the code posted by @ashakantasharma will need to be in a Workbook_open macro in the "ThisWorkbook" module

 

[Raffe123]

Thanks for the response, but the hide will not hide the row

 

[Michael M]

What row is that ??... in the attachment you provided ??
It looks like the formula bar to me !!