Problem hiding/unhiding columns using combo control

  • Thread starter Thread starter olivier durand
  • Start date Start date
O

olivier durand

Hi,

In the thread titled "Combobox challenge" a solution is given to
format a sheet using a combo control:
http://www.google.com/groups?hl=en&...ta=group%3Dmicrosoft.public.excel.programming

I have tried this and it works indeed for "forms" controls. However
when I use a combobox control from the "control toolbox" toolbar
however it fails. My macro comes up with the following message:
"Unable to set the Hidden property of the range class"

Anybody got an idea?

Any help much appreciated

Olivier

PS: The code called from the two controls is the same.
 
If you are using Excel 97, change the takefocusonclick property of the
commandbutton to false.
 
Hi
Right click the control, go to Format Control... and look at
Properties. You want to select "move and size with cells". You can get
this problem with any shape on a worksheet, including comments.
regards
Paul
 
Back
Top