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.