How do I make a cell into a button that runs a macro?

**rookie37** · 06-13-2010, 03:29 AM

I will have 12 tabs. I want to have 12 buttons that will turn on and off these tabs

Example

Please Login or Register  to view this content.

By the way, I love this forum. I'm learning a lot. Only yesterday I didn't know how to do anything except record keystrokes. Now I'm writing code.

**scottwhittaker2333** · 06-13-2010, 03:38 AM

As far as I know you can't actually turn a cell into a button, However you can add command buttons to your spreadsheet and then assign codes to them. If you are using excel 2007 its under the developer tab, click insert and choose a button type from form controls. If you are using 97 to 03 then you will have to add it to your toolbar. If I remember correctly then itsinsert tools and command or something like that.

**pike** · 06-13-2010, 03:47 AM

maybe use..

Please Login or Register  to view this content.

or a clear (no colour) shape over the cell with the macro assigned to it

How do I make a cell into a button that runs a macro?

LinkBack

Thread Tools

Rate This Thread

Display

How do I make a cell into a button that runs a macro?

Re: How do I make a cell into a button that runs a macro?

Re: How do I make a cell into a button that runs a macro?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions