I've done a lot of ribbon work and have not had any problem with dynamic
controls and locked VB projects. So naturally I'm a bit skeptical that this
is an Excel bug. But anything is possible, of course. If you want to send
me a simple example that demonstrates the problem I'd be happy to look at it
and try to find a solution.

But then my VBA codes are not hidden, only protected for modifying it.

That's not true. When a VB project is viewable it can be modified.

--
Jim
"tarongazoo" wrote in message
...
| Hello,
|
| In Excel 2007, on the Ribbon I add a new tab. I have a combobox that lists
| all my opened Excel files' name and it updates automatically whenever I
click
| on it. This worked fine, until I add a password to my VBA Project. The
update
| of this combobox with the actual files won't work anymore.
|
| I found out, that when I uncheck the checkbox for "Lock project for
viewing"
| in VBAProject Properties the combobox works fine. But then my VBA codes
are
| not hidden, only protected for modifying it.
|
| And when I click this check box and restart Excel, my combobox dies
| (actually it works for the first time, but later on won't refresh the
list).
|
| I tried this on other computer and it works the same way, so the bug is
not
| with my PC.
|
| Please help me. Is there an update patch to solve my problem? My Office
2007
| is updated to the latest version.
|
| Best Regards,
| Laci