View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default 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