View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Standefer Rob Standefer is offline
external usenet poster
 
Posts: 1
Default Hiding controls with rows

I have several controls in a named range. When I hide the range, the
controls all roll up on each other and aren't hidden (the same thing
happens if I delete the range).

I'm using this code:

Me.[RangeName].Rows.RowHeight = 0

Any suggestions on how I can get the controls to hide too? They are
Excel forms controls, not ActiveX.

Thanks,
Rob