?ObjExcel.Worksheets(2).OLEObjects(nObj).Object.Value

>Thanks for the help. I created a new spreadsheet and the code works with your changes but nothing works on the spreadsheet that I need to modify. (The COUNT is always 0 in my main spreadsheet so the FOR...NEXT never occured.) I just realized that it's password protected so that's probably hiding the controls. I'll just work on a new spreadsheet for now until I can contact somebody about getting the password.
>
>Next question:
>Do you know how to set/get the values of the controls?
>
>I tried "oWorkSheet.OLEOBJECTS(nObj).VALUE" to get the value of a CheckBox but an "Unknown name" error occurs.