Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
resizing buttons
I have a workbook with 2 buttons that contain macros.
Running another macro writes data to the sheet with the 2 buttons. At the end, it formats the data in various columns; which changes the size of one of the buttons. I'm looking for some help to resize the buttons at the end of this macro to what it was before the columns (with data) was resized. Thanks for the help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
resizing buttons
Instead of resizing after, how about just telling excel not to change its size
before? If you rightclick on the button, you can select Format Control. Then on the properties tab, there's an option (or two) to not resize with cells. JT wrote: I have a workbook with 2 buttons that contain macros. Running another macro writes data to the sheet with the 2 buttons. At the end, it formats the data in various columns; which changes the size of one of the buttons. I'm looking for some help to resize the buttons at the end of this macro to what it was before the columns (with data) was resized. Thanks for the help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Form buttons vs. ActiveX Buttons | Excel Discussion (Misc queries) | |||
have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
Resizing cells in a selection without resizing entire sheet | Excel Discussion (Misc queries) | |||
Control Buttons vs. Command Buttons | Excel Programming |