set command button on a worksheet

  • Thread starter Thread starter Bythsx-Addagio
  • Start date Start date
B

Bythsx-Addagio

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
 
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.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button Question 8
URGENT help needed for a macro to place and size command button 7
Referencing command button on worksheet from VBA 3
How to use multiple command button to copy user form data to multiple worksheet 0
Set Command button location 1
Better looking command buttons on a worksheet 1
command button 2
Referencing a Forms Button in a Worksheet 7

Back
Top