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. |
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. |
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. |
All times are GMT +1. The time now is 10:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com