hide/unhide rows using commandline

[bloody_vixen31]

Hi,

I am running an excel file using the batch mode. I was able to hide the specific row I need but I was unable to unhide it.

The requirement is to hide row 7 and button 7 when you type in the commandline /btns:ON

I have used the following code:
Private Sub Workbook_Open()
Dim CmdRaw As Long
Dim CmdLine As String
Dim buton As String
CmdRaw = GetCommandLine
CmdLine = CmdToSTr(CmdRaw)
buton = m_ExtractVariable("/btns:", CmdLine)

If buton = "ON" Then
Sheets("Summary").Rows("7:7").EntireRow.Hidden = False
Sheets("Summary").Shapes("Button 7").Visible = True
Else
Sheets("Summary").Rows("7:7").EntireRow.Hidden = True
Sheets("Summary").Shapes("Button 7").Visible = False
End If


Thank you.

 

[bloody_vixen31]

thanks for your help. I have already done it on my on.