| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to modify property of an object
In Excel 2007, how would you write a macro to set the Enabled property
of multiple DTPicker objects ? The DTPicker object comes from the Microsoft Date and Time Picker Control 6.0. http://support.microsoft.com/kb/297381 For example, there are two DTPicker objects, DTPicker1 and DTPicker2. Macro1 will set their Enabled property to TRUE. Macro2 will set their Enabled property to FALSE. Exceluser |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modify Insert Object Macro | Excel Programming | |||
| Modify the IgnoreBlank property of the Validation object | Excel Programming | |||
| HELP CANNOT MODIFY BUTTON OBJECT OR SEE ITS PROPERTIES.... | Excel Programming | |||
| TO MODIFY A EXCEL OBJECT FROM WORD USING VBA | Excel Programming | |||
| Loop thru multiple files - Modify worksheet visible property | Excel Programming | |||
Threaded Mode
