Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro-Button make tu hide?
Hi, cann I the macro-button make to hide? Optional - dependent from the cell value. Please, don't say NO! Thenks F.Verga -- freni ----------------------------------------------------------------------- frenic's Profile: http://www.excelforum.com/member.php...fo&userid=2529 View this thread: http://www.excelforum.com/showthread.php?threadid=38787 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro-Button make tu hide?
You probably can with the visible property. And do it in a macro.
But a lot depends on what kind of button it is: toolbar forms toolbox control toolbox text box shape or built from a macro. Do you know about event macros? There is a way to capture the cell change... Tell us more... Where does the button come from (how did you build it) What changes the cell value (formula, manual entry, etc). What is it you really want to do... -- steveB Remove "AYN" from email to respond "frenic" wrote in message ... Hi, cann I the macro-button make to hide? Optional - dependent from the cell value. Please, don't say NO! Thenks F.Vergan -- frenic ------------------------------------------------------------------------ frenic's Profile: http://www.excelforum.com/member.php...o&userid=25297 View this thread: http://www.excelforum.com/showthread...hreadid=387878 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro-Button make tu hide?
Hi F,
Assume the button is from the Forms Toolbar and is named "MyButton" Assume that A1 is the cell to be used to show/hide the buttom Assume that A1 contains a formula In the sheet module, paste the following event code: Private Sub Worksheet_Calculate() Me.Shapes("Button 1").Visible = _ Range("A1").Value < 10 '<<====== CHANGE End Sub As this is worksheet event code, it should be placed in the worksheet module, not a standard module. Right-click the worksheet tab, select 'View Code' and paste te above code. Alt-F11 to return to the worksheet. Change the cell address (A1) and the test value (< 10) to suit your requirements. --- Regards, Norman "frenic" wrote in message ... Hi, cann I the macro-button make to hide? Optional - dependent from the cell value. Please, don't say NO! Thenks F.Vergan -- frenic ------------------------------------------------------------------------ frenic's Profile: http://www.excelforum.com/member.php...o&userid=25297 View this thread: http://www.excelforum.com/showthread...hreadid=387878 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro-Button make tu hide?
The question doesn' make an awful lot of sense. Can you try to re-phrase it,
as to what sort of button, what you want to hide, and what the optional means in this context? -- HTH RP (remove nothere from the email address if mailing direct) "frenic" wrote in message ... Hi, cann I the macro-button make to hide? Optional - dependent from the cell value. Please, don't say NO! Thenks F.Vergan -- frenic ------------------------------------------------------------------------ frenic's Profile: http://www.excelforum.com/member.php...o&userid=25297 View this thread: http://www.excelforum.com/showthread...hreadid=387878 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro-Button make tu hide?
Hi F,
Assume the button is from the Forms Toolbar and is named "MyButton" Should read: Assume the button is from the Forms Toolbar and is named "Button 1" --- Regards, Norman "Norman Jones" wrote in message ... Hi F, Assume the button is from the Forms Toolbar and is named "MyButton" Assume that A1 is the cell to be used to show/hide the buttom Assume that A1 contains a formula In the sheet module, paste the following event code: Private Sub Worksheet_Calculate() Me.Shapes("Button 1").Visible = _ Range("A1").Value < 10 '<<====== CHANGE End Sub As this is worksheet event code, it should be placed in the worksheet module, not a standard module. Right-click the worksheet tab, select 'View Code' and paste te above code. Alt-F11 to return to the worksheet. Change the cell address (A1) and the test value (< 10) to suit your requirements. --- Regards, Norman "frenic" wrote in message ... Hi, cann I the macro-button make to hide? Optional - dependent from the cell value. Please, don't say NO! Thenks F.Vergan -- frenic ------------------------------------------------------------------------ frenic's Profile: http://www.excelforum.com/member.php...o&userid=25297 View this thread: http://www.excelforum.com/showthread...hreadid=387878 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
URGENT!! Use macro button to hide empty columns and rows...HELP!!!! | Excel Programming | |||
Make more info appear when mouse moves over a macro command button | Excel Programming | |||
Make macro-button sheet reference relative | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
Make a cell into a Macro button | Excel Programming |