streaching buttons when showing and hiding rows

han_u_man · General User Joined: 01 Sep 2010 Posts: 6

I have a complex set of sheets including a macro which shows and hides rows depending on users entering a number into a cell (thanks to the clever people on this site!)

I have a couple of form push buttons used to run other custom macros written in oo basic.
The buttons are positioned in the rows which can be hidden.
When those rows are unhidden the buttons are stretched and/or moved.

I tried everything I can think, form properties, linking to cell, keep position etc, to keep the buttons size and position fixed.

Can anyone help with keep the buttons size and position fixed or suggest another way run the macros?

ken johnson · Posted: Thu Jun 09, 2011 5:15 pm Post subject:

Maybe put the buttons on a toolbar.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

han_u_man · General User Joined: 01 Sep 2010 Posts: 6

thanks for the reply, certainly possible, but i was trying to keep the buttons near the cells containing the relevant information.

han_u_man · General User Joined: 01 Sep 2010 Posts: 6

bump?