Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable macros in a worksheet
Hi...
I have a workbook with 10 sheets with 15 buttons (with macros) per sheet. Is it possible to enable/disable these buttons based on a a value entered in a cell? e.g. If the user enters a value into cell A1 he can begin to navigate the workbook using the buttons/macros? Someone must be clever out there. Thanks G |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable macros in a worksheet
You need to add a validation routinte to each command button that checks the
value of cell A1. Depending on the value exit sub or continue. There is no silver bullet on this one... -- HTH... Jim Thomlinson "Gordon" wrote: Hi... I have a workbook with 10 sheets with 15 buttons (with macros) per sheet. Is it possible to enable/disable these buttons based on a a value entered in a cell? e.g. If the user enters a value into cell A1 he can begin to navigate the workbook using the buttons/macros? Someone must be clever out there. Thanks G |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable macros in a worksheet
Hi...Where do I find the validation option in the code settings for the
command button? "Jim Thomlinson" wrote: You need to add a validation routinte to each command button that checks the value of cell A1. Depending on the value exit sub or continue. There is no silver bullet on this one... -- HTH... Jim Thomlinson "Gordon" wrote: Hi... I have a workbook with 10 sheets with 15 buttons (with macros) per sheet. Is it possible to enable/disable these buttons based on a a value entered in a cell? e.g. If the user enters a value into cell A1 he can begin to navigate the workbook using the buttons/macros? Someone must be clever out there. Thanks G |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable macros in a worksheet
You build it yourself
Private Sub CommandButton1_Click() If Not IsGoodToGo Then Exit Sub End Sub Public Function IsGoodToGo() As Boolean IsGoodToGo = False If Range("A1").Value = "Something" Then IsGoodToGo = True End Function -- HTH... Jim Thomlinson "Gordon" wrote: Hi...Where do I find the validation option in the code settings for the command button? "Jim Thomlinson" wrote: You need to add a validation routinte to each command button that checks the value of cell A1. Depending on the value exit sub or continue. There is no silver bullet on this one... -- HTH... Jim Thomlinson "Gordon" wrote: Hi... I have a workbook with 10 sheets with 15 buttons (with macros) per sheet. Is it possible to enable/disable these buttons based on a a value entered in a cell? e.g. If the user enters a value into cell A1 he can begin to navigate the workbook using the buttons/macros? Someone must be clever out there. Thanks G |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable macros in a worksheet
You did mean CommandButton when you said "button", right?
Which "buttons" did you use... the ones from Form's toolbar or the Control Toolbox toolbar? -- Rick (MVP - Excel) "Gordon" wrote in message ... Hi... I have a workbook with 10 sheets with 15 buttons (with macros) per sheet. Is it possible to enable/disable these buttons based on a a value entered in a cell? e.g. If the user enters a value into cell A1 he can begin to navigate the workbook using the buttons/macros? Someone must be clever out there. Thanks G |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable macros in a worksheet
I was able to do the following with CommandButton1 using Control Toolbox and
Sheet1 Object: Private Sub CommandButton1_Click() Range("A2").Value = "Cochrane" End Sub Private Sub Worksheet_Change(ByVal Target As Range) If Range("A1").Value = "Orion" Then CommandButton1.Enabled = True Else: CommandButton1.Enabled = False End If End Sub I tested it and it works. Substitute with your CommandButton1_Click actions. -- I am running on Excel 2003, unless otherwise stated. Please rate posts so we know when we have answered your questions. Thanks. "Gordon" wrote: Hi... I have a workbook with 10 sheets with 15 buttons (with macros) per sheet. Is it possible to enable/disable these buttons based on a a value entered in a cell? e.g. If the user enters a value into cell A1 he can begin to navigate the workbook using the buttons/macros? Someone must be clever out there. Thanks G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Macros through VBA | Excel Programming | |||
how do i disable macros? | Excel Discussion (Misc queries) | |||
disable macros? | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
en-/disable macros pop-up | Excel Programming |