Text boxes and Command Boxes resizing

Hi all,

i am running a command button with a macro to print all sheets with one pres of the button and then return to a specific location in one worksheet.

when i then look at some of the text boxes and command buttons they have moved location and changed sixe. i have selected dont move or resizt option but this doesnt help.

has anyone got some advice?

D

You're better off not using ActiveX controls on worksheets at all. They're incredibly unstable have a look here https://www.google.co.uk/webhp?sourc...eet%20controls and by using them, you're asking for trouble.

Forms controls are much more reliable - they're in the same dropdown as the ActiveX ones, but are designed for use on worksheets - so you don't run into any stability issues, you can do most of the same things with them too and you can use them without using code.

Great thanks will have a good look.

Hi i cant use the form controls it seems to be grey out

D

All of them?

I have put a screen shot on the following file.

They don't look greyed out....