Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding a row
I'm a newbe with Excel vb. I've done a lot of vb with word but, have a
project with excel. I have a spreadsheet which gets populated upon open like so: Private Sub Workbook_Open() Set objIRConn = CreateObject("irdesktopcontrol.irdesktopcontrolx") objIRConn.Active = True 'Compnay If Sheet1.Cells(4, 7) = "" Then strCo = objIRConn.Filename Sheet1.Cells(4, 7) = strCo End If What I want to do is hide row a90 if this is blank. The Sheet is protected. Thanks, Bryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding | Excel Discussion (Misc queries) | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
Hiding #N/A | Excel Discussion (Misc queries) | |||
Hiding Column Also hiding text | Excel Programming | |||
hiding #N/A | Excel Programming |