Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change activex control properties from a macro
I want to change the properties of a button on a worksheet when the workbook
is opened so that if a cell contains a certain value the button is inactive if the cell doesn't contain that value the button is active. I am using Office XP. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change activex control properties from a macro
Quick sample: (Paste into This Workbook module) of your file:
and change accordingly (cells and values) Private Sub Workbook_Open() With Worksheets("Sheet1") .CommandButton1.Enabled = True If .Range("B4").Value = 6 Then .CommandButton1.Enabled = False End If End With End Sub "Billums" wrote: I want to change the properties of a button on a worksheet when the workbook is opened so that if a cell contains a certain value the button is inactive if the cell doesn't contain that value the button is active. I am using Office XP. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change activex control properties from a macro
Thanks for that. I have done this before (a long time ago) and when I tried
to do it now I couldn't get it to work. Why? Because I had omitted the period at the beginning of the control name. :-( "Jim May" wrote: Quick sample: (Paste into This Workbook module) of your file: and change accordingly (cells and values) Private Sub Workbook_Open() With Worksheets("Sheet1") .CommandButton1.Enabled = True If .Range("B4").Value = 6 Then .CommandButton1.Enabled = False End If End With End Sub "Billums" wrote: I want to change the properties of a button on a worksheet when the workbook is opened so that if a cell contains a certain value the button is inactive if the cell doesn't contain that value the button is active. I am using Office XP. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Event Macro adjustment needed - need to change font color also | Excel Worksheet Functions | |||
Change macro to paste as last sheet | Excel Discussion (Misc queries) | |||
assign a macro to a control button | Excel Discussion (Misc queries) | |||
How do I link a macro to an ActiveX control? | New Users to Excel | |||
How do I link a macro to an ActiveX control? | New Users to Excel |