Excel VBA Objects corrupted by Windows 7 Profile

dbnewlon

New Member
Joined
Apr 29, 2011
Messages
1
I have an Excel VBA program I wrote 3 years ago that interfaces to Oracle through OO4O. It has worked great since. In the last few days, when I open the spreadsheet, all the buttons appear as 8 tiny circles (in dev mode) and in executable mode they are just invisible. I can make them visible by clicking the edge of the button, but then they disappear again when I click elsewhere in the spreadsheet. The buttons are there, I just can see them - I can even click them and the VBA programing behind the buttons still work fine. Now, here is the kicker, I know it is something in my Windows 7 Profile that is causing it because when I have someone else log into my pc under a different profile and open the spreadsheet, the buttons appear fine.
Has anyone else had this problem and if so, what did you do to correct it. I know I could just erase my profile and start from scratch, but I have a pretty involved profile and would like to avoid that if I could. Thanks to any of you Excel experts that can help point me to a solution.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top