View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erik Andreassen[_2_] Erik Andreassen[_2_] is offline
external usenet poster
 
Posts: 3
Default locking check boxes using a macro

Hi,

Does anyone know a good way to lock all checkboxes (or other user form
objects) on a worksheet using an excel macro? I have a macro that will cycle
through all the worksheets in a workbook, and it needs to set the lock
property on all check boxes it finds along the way.


Thanks!