Problem hiding/unhiding columns using combo control


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.
 
Ad

Advertisements

T

Tom Ogilvy

If you are using Excel 97, change the takefocusonclick property of the
commandbutton to false.
 
Ad

Advertisements

P

Paul Robinson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top