"floating' button

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I have a drop down box and well below that a control
button to run a macro. For some reason at some point the
drop down button moves to the inside of the cell, and the
button moves to the same cell and the will disappear. Any
ideas???
 
Hi,

This happened to me once.

When you recorded the macro, I guess you moved down a cell or whatever,
so that each time you run the macro things get shifted.

Look closely at the macro and watch carefully the start and end
locations of the active cell.
 
It worked fine for a while. This 'behavior' just started
Have made minor changes to macro but no cell locations.
 
I don't have an answer, but is your button from the Forms toolbar or from the
control toolbox toolbar? (It sounded more like the control toolbox toolbar from
your wording.)

If it's from the control toolbox toolbar, can you try to replace it with one
from the Forms toolbar and see what happens?

You'll probably want to move your code from behind the sheet to a general module
and you'll have to assign that new macro to your button, but it might be worth
the effort. (You will lose a bunch of features by moving to the Forms version,
though.)

(I almost always use the Forms button for simple stuff and I've never seen
anything like this--but it's still just a guess.)
 
Back
Top