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&l...el.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.

--
Regards,
Tom Ogilvy

"olivier durand" wrote in message
om...
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&l...el.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.

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

(olivier durand) wrote in message . com...
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&l...el.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.