Buttons resizing by themselves

**Marcelo Rychter** · 11-06-2012, 08:54 PM

Hi all,

In a presentation, using datashow, the buttons in a sheet change their sizes. How can I avoid that?

Thanks in advance,
Marcelo Rychter

**Ron Coderre** · 11-06-2012, 09:48 PM

I'm guessing you used the ActiveX button controls. I've had nothing but trouble with them. I use the Form Controls without incident.

**Winon** · 11-06-2012, 10:51 PM

Even if you use Form Control Buttons you will have to right click on the Button, select Format Control, Click on Properties, and the choose Move but don't size with Cells or Don't move and size with Cells.

**Marcelo Rychter** · 11-07-2012, 05:11 AM

Hi Winon, thanks for your help.

In fact I'm using Active X controls. The only property related to size is Autosize, which value is False. There is no "Move but don't size with Cells" property. Do you have any other suggestion?

Thanks,
Marcelo Rychter

**Kyle123** · 11-07-2012, 05:15 AM

Replace them with forms buttons?

**Marcelo Rychter** · 11-07-2012, 08:26 AM

Hi Kyle,

I have to use Active X buttons because I need several of their properties, which forms buttons don't have.

Cheers,
Marcelo Rychter

**Kyle123** · 11-07-2012, 08:27 AM

Which properties? There may be workarounds

**Ron Coderre** · 11-07-2012, 10:23 AM

ActiveX controls in Excel are like the little girl with the curl on her forehead...When she's good, she's very, very good...BUT...When she's bad, she's very, very BAD.

**Winon** · 11-07-2012, 11:27 AM

@ Ron Coderre,

Very well put. LOL.

@ Marcelo Rychter,

I suspect there could be a conflicting problem somewhere between your computer's BIOS setup or the same with the other Machine. Start your machine in Safe Mode, and see if the Buttons still "contorts". If not, try selecting different, video displays within the BIOS Setup and restart your machine (or the same with the other machine) until the Buttons remain as it should.

Hope that helps!

**Ron Coderre** · 11-07-2012, 02:10 PM

@Winon
This problem has been around ever since MS included ActiveX controls to Excel VBA. The implementation seems to have been an incomplete thought and...to my knowledge...the problem has never been addressed.

**Winon** · 11-07-2012, 03:19 PM

@ Ron Coderre,

Hi Ron,

Thank you for responding. And a big YES, I could not agree with you more on that point.

**Marcelo Rychter** · 11-08-2012, 08:17 PM

Hi Winon,

Thanks for your help. I'll try your suggestions.

Another fact: that happens only in one model of datashow. I tried with two other datashows and it worked properly. I'm trying to understand why.

Take care,
Marcelo Rychter

**Winon** · 11-09-2012, 01:47 AM

Hello Marcelo Rychter,

You are welcome.

Buttons resizing by themselves

LinkBack

Thread Tools

Rate This Thread

Display

Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Re: Buttons resizing by themselves

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions