set command button on a worksheet
 

Hello,
I have a worksheet that I would like to use as a switchboard that will be
full of command buttons that will each run a different unrelated macro.
Because there are so many command buttons, I was wondering if there is a way
to put them directly in a cell. It doesn't have to be a command button.
Just some object that will fill the cell and resize with the row and column
and pretty much act the same way as the cell where it is set. Some raised
feature or rendering would be nice so the user can easily identify that it is
clickable.

I would prefer to set this during the design, and not at runtime.

Is this possible?

Thanks

set command button on a worksheet
 

The easiest way to manage groups of buttons is to use the options under Draw
on the drawing toolbar. That will allow you to align and distribute the
buttons as necessary. It only take s few moments to get all of the buttons
configured.
--
HTH...

Jim Thomlinson


"Bythsx-Addagio" wrote:

Hello,
I have a worksheet that I would like to use as a switchboard that will be
full of command buttons that will each run a different unrelated macro.
Because there are so many command buttons, I was wondering if there is a way
to put them directly in a cell. It doesn't have to be a command button.
Just some object that will fill the cell and resize with the row and column
and pretty much act the same way as the cell where it is set. Some raised
feature or rendering would be nice so the user can easily identify that it is
clickable.

I would prefer to set this during the design, and not at runtime.

Is this possible?

Thanks

set command button on a worksheet
 

Thank you very much for the suggestion. However, I will still have the
problem of whenever a new row or column is created my buttons will no longer
be lined up properly. The ideal thing would be to be able to click on a
particular cell to run a specific macro. Can I use a hyperlink to run a
macro?



"Jim Thomlinson" wrote:

The easiest way to manage groups of buttons is to use the options under Draw
on the drawing toolbar. That will allow you to align and distribute the
buttons as necessary. It only take s few moments to get all of the buttons
configured.
--
HTH...

Jim Thomlinson


"Bythsx-Addagio" wrote:

Hello,
I have a worksheet that I would like to use as a switchboard that will be
full of command buttons that will each run a different unrelated macro.
Because there are so many command buttons, I was wondering if there is a way
to put them directly in a cell. It doesn't have to be a command button.
Just some object that will fill the cell and resize with the row and column
and pretty much act the same way as the cell where it is set. Some raised
feature or rendering would be nice so the user can easily identify that it is
clickable.

I would prefer to set this during the design, and not at runtime.

Is this possible?

Thanks