| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unable to set hidden property
I copied this code straight from this NG, but it doesn't run for me.
Sub HideCol() Range("H:H").Hidden = True End Sub I get an error, "Unable to set the hidden property of the range class". Is is someting to do with the version of XL? I'm using XL2000. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unable to set hidden property
"davegb" wrote in message oups.com... I copied this code straight from this NG, but it doesn't run for me. Sub HideCol() Range("H:H").Hidden = True End Sub I get an error, "Unable to set the hidden property of the range class". Is is someting to do with the version of XL? I'm using XL2000. Wild guess. The worksheet or workbook is protected. /Fredrik |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unable to set hidden property
Try
columns("H:H").Hidden = True -- HTH RP (remove nothere from the email address if mailing direct) "Fredrik Wahlgren" wrote in message ... "davegb" wrote in message oups.com... I copied this code straight from this NG, but it doesn't run for me. Sub HideCol() Range("H:H").Hidden = True End Sub I get an error, "Unable to set the hidden property of the range class". Is is someting to do with the version of XL? I'm using XL2000. Wild guess. The worksheet or workbook is protected. /Fredrik |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to match property error | Excel Discussion (Misc queries) | |||
| Unable to set the XValues Property | Charts and Charting in Excel | |||
| Run Time Error 1004 Unable to set hidden property | Excel Programming | |||
| Unable to get VLOOKUP property | Excel Programming | |||
| unable to set the OnAction Property of the Text Box | Excel Programming | |||
Linear Mode
