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.

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

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