Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() This may be a silly easy question, but im new to Excel so Id appreciate someone's help. I was wondering if its possible to create a button such that the button is a cell itself. So that when you click the cell, it executes the macro assigned to the button. Also, the button would need to keep the size and coordinates of the cell to which it is created into. If Im not being clear please let ,me know. Thanks -- jpizzle ------------------------------------------------------------------------ jpizzle's Profile: http://www.excelforum.com/member.php...o&userid=23920 View this thread: http://www.excelforum.com/showthread...hreadid=375550 |
#2
![]() |
|||
|
|||
![]()
You can put a button from the Forms toolbar over that cell. If you rightclick
on the button and choose format control|properties tab, you can specify that it move and size with cell. And if you position the edges of the button while holding the alt-key, the button will "snap-to" the edge of the cell. (Rightclick on the button and then assign macro will assign the macro to the button.) jpizzle wrote: This may be a silly easy question, but im new to Excel so Id appreciate someone's help. I was wondering if its possible to create a button such that the button is a cell itself. So that when you click the cell, it executes the macro assigned to the button. Also, the button would need to keep the size and coordinates of the cell to which it is created into. If Im not being clear please let ,me know. Thanks -- jpizzle ------------------------------------------------------------------------ jpizzle's Profile: http://www.excelforum.com/member.php...o&userid=23920 View this thread: http://www.excelforum.com/showthread...hreadid=375550 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Editing cell using right mouse button | New Users to Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
adding a command button to an excel cell? | Excel Discussion (Misc queries) | |||
Clear cell contents with a button | Excel Worksheet Functions | |||
Dropdown with a "jump to" cell name. Like a Go button.. | Excel Worksheet Functions |