Button Magically moves....

[ceshelman]

I am having a unique intermittent problem I am hoping someone can hel
me with. I have a large Excel VPA application that has several button
on the "Config" sheet that execute different VBA scripts. There ar
also a large number of drop down list boxes. On a fairly regular basi
an unusual behavior occurs, when you click on a drop down box one of th
buttons (always the same button) magically moves to the drop down bo
that was clicked. Once this happens the first time, every time yo
click on a drop down box the button moves to that box. You can clos
and reopen the file and it will continue to happen. I have not bee
able to find any way to fix the file once this starts happening. An
ideas on what is causing this and/or what I can do to fix it?

I had been fortunate until today and the master file had never had thi
problem. Now the master that I do all my development work on has gotte
corrupted

 

[keepITcool]

this it?
Controls move to the left of the worksheet in Microsoft Excel 2002
see http://support.microsoft.com/kb/838910/




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


ceshelman wrote :

 

[ceshelman]

Close but not quite. Thanks for the input but this problem has to d
with Print Preview not clicking on a drop down box. I did try th
recommended solution but it had no affect on the problem

 

[NickHK]

ceshelman,
I have had the same problem with Data Validation drop downs for a year or so
on a template file. It is certainly intermittent.
Last year I looked around, but could find no other comments/remedies.

If you find any remedy or reason, let us know.

NicHK

 

[okaizawa]

Hi,
the conflict of object-ids used internally in that sheet might be the cause.
copying all cells to a new sheet would fix the problem.
i don't know what makes them wrong.