RE: $$Excel-Macros$$ How To Change Properties Of Form Controls

2011-06-23 Thread Daniel
If Next sh End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de deepu Envoyé : jeudi 23 juin 2011 17:00 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ How To Change Properties Of Form Controls Hi Guy's, I&

$$Excel-Macros$$ How To Change Properties Of Form Controls

2011-06-23 Thread deepu
Hi Guy's, I've 20 command buttons on a worksheet to be used for different purposes. I've write a code to disable and enable all of them accordint to situations. All the buttons have a common naming standard, e.g. "B1C1","B1C2","B1C3","B1C4","B2C1","B2C2". I've tried with the following code..