Control Button on Excel Form Keeps Moving Around

[VAST39]

Hi guys,

I have a macro enabled Excel worksheet that I set up to automatically import data from an Access table. I recorded a macro of maually doing the import. Then I placed a control button on the sheet to execute the macro when the user clicks on the button.

It works fine except for one annoying problem. Every time you click on the button, the button shifts columns on the right. For example, if I place the button in column K, it moves the button to column M after the import. Then if you run it again, it shifts it to column R. I want the button to stay static in place.

Anyone have any suggestions here?

 

[SkipVought]

hi,

Macro? Please post you question AND CODE in forum707. This is not the best forum to address VBA.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[combo]

Depending on settings, shapes can move, resize or stay fixed when you add, delete or resize cells. You can right-click the shape and format this, together with option to print the shape. In case of vba controls you have to switch to design mode first. The other way: in VBE you have to set "Placement" property of the control t0 3 (xlFreeFloating).

combo