View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jarle Jarle is offline
external usenet poster
 
Posts: 32
Default Protect several objects

I have several textboxes on a worksheet.

I will have to protect the text in these boxes with help of vba code. When
protecting text in one specific textbox I use:

Worksheets(1).Shapes("txtbox1").LockedText = True

I want to protect all boxes with one command. I am thinking about something
like

For each Textbox in Worksheets(1)
LockedText = True

I am struggling with the syntax to make this work. Can anybody help me out?

rgds
Jarle

..