Thread: Macro to modify property of an object
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
exceluser exceluser is offline
external usenet poster
  
Posts: 13
Default 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
Reply With QuoteReply With Quote