
July 7th, 2003, 07:30 PM
|
|
Junior Member
|
|
Join Date: Jul 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
VBA remove controls
I have a VBA application in which there are some controls associated with macros.
The controls are not VB controls but added using View
-->Toolsbars-->Forms.
I have one of the functionalities where in a report needs to be created which disables and removes the all the macro code and removes all controls on the sheets.
I could remove the associated code but am unable to remove the controls.
I know methods to remove VB controls (associated with names) but any pointers to remove such form controls wud be helpful.
I tried using selectAll and remove methods but it triggered a outofmemory error.
|