View Single Post
  #2 (permalink)  
Old September 23rd, 2005, 11:39 AM
echovue echovue is offline
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

What you really want is a Control Array, but I don't think VBA supports that. Try this, I modified it from some code I found in the Excel VBA forum.

dim bx as object
for each bx in controls
   if left(bx.name,1)="t" then
      bx.Locked=true
   end if
next

Let me know if that works, if not, I know I have done this before, it's just a matter of finding out where!

Mike

Mike
EchoVue.com
Reply With Quote