Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with automating spreadsheet containing VBA code
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00736099
Message ID:
00736123
Views:
21
Try Worksheets().SHAPE objects. They themselfes can be olecontrols.

>Yes, I found an unprotected version of the spreadsheet but the controls still don't show up in the OLEOBJECTS collection. The only difference between the forms (that I can see) is that I can modify the properties of the controls in Design Mode.
>
>>You mentioned in your previous related post that there is a password protection for VB code in the file. Did you get a password?
>
>>>I finally figured out how to access and modify controls on an Excel spreadsheet but no matter what I do, I can't access the controls on one of my spreadsheets. It has VBA macros and the controls (Option buttons and comboboxes) look and behave different than the ones supplied with Excel. I didn't create this spreadsheet and I'm still trying to contact the person who did but I need to figure this out soon.
>>>
>>>Any idea on what's not allowing me to see the spreadsheet's controls? Any help would be appreciated. Thank you.
Previous
Reply
Map
View

Click here to load this message in the networking platform