Macro Buttons seem to start resizing themselves

[ijourneaux]

I have several buttons on on work sheet. At some point, they decide to start resizing themselves. AN internet search seems to indicate this is a common problem.

I am not married to command buttons is there an option for these macros that would avoid the automagically resized buttons.

Ian

 

[Fluff]

Sounds like you are using ActiveX buttons, if so you could replace them with Forms Control buttons, or shapes.

 

[DataBlake]

is there an option for these macros that would avoid the automagically resized buttons.

do you mean to initiate a macro? there are plenty.
what is the command button for?

you could do any number of things to start a macro. I personally like double clicking cells.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If Target.Address = "$D$2" Then
   Sheets("WheelPros").Select
   WheelPros.Show
   Sheets("Program Start").Select

End If

end sub

The above code is something where you double click cell D2 on my first sheet and it pops up a userform and then changes the sheet (because D2 is obviously for a specific brand)
you can get very creative with initiating macros automatically or manually.

 

[ijourneaux]

I am going to give this approach a try. It should work for my needs.

 

[ijourneaux]

Sounds like you are using ActiveX buttons, if so you could replace them with Forms Control buttons, or shapes.

Will give this a try as well.

Thanks for the tips

 

[Fluff]

You're welcome & thanks for the feedback

 

[ijourneaux]

The buttons I am having problems with were Form Control buttons, not ActiveX, so that wasn't the issue. In my websearch on the problem, the problem seems to be initiated by a change in screen resolution.

 

[ijourneaux]

I tried using the BeforeDoubleClick approach. That worked but the fact that the hyperlink call (used elsewhere in the workbook) only uses 1-click makes it confusing for users.(i.e. someplace use 1 click, others use 2 clicks).

THat is what I have for now but need to come up with a robust solution for macro buttons on work sheets. I have about 10 buttons.