Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Toggle Button
Hi all, I am looking a putting a VB command button on one of my sheets, which when pressed once it does one thing, then when pressed again it does something different. e.g. when pressed first time it hides a range of rows, when pressed again it unhides them. Hope you can help Dave -- Dave_2k5 ------------------------------------------------------------------------ Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667 View this thread: http://www.excelforum.com/showthread...hreadid=401062 |
#2
|
|||
|
|||
You will find an answer in your other post. Please do not post to multiple categories - your question will get seen whichever category it is in. DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=401062 |
#3
|
|||
|
|||
Here is a macro that you can assign to a forms toolbar button
Sub myMacro() Static fOn As Boolean fOn = Not fOn Rows("1:3").Hidden = fOn End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Dave_2k5" wrote in message ... Hi all, I am looking a putting a VB command button on one of my sheets, which when pressed once it does one thing, then when pressed again it does something different. e.g. when pressed first time it hides a range of rows, when pressed again it unhides them. Hope you can help Dave -- Dave_2k5 ------------------------------------------------------------------------ Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667 View this thread: http://www.excelforum.com/showthread...hreadid=401062 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toggle button text color | Excel Discussion (Misc queries) | |||
Place the caption of a toggle button into a cell | Excel Worksheet Functions | |||
Command Button anomalies | Excel Discussion (Misc queries) | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
Toggle betwen "editing" and "pushing" a button in excel | Excel Discussion (Misc queries) |