Button Size as s Cell Size?

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Re: Button Size as s Cell Size?

    Hi Jonny

    Best way is to use a CommandButton from the Control Toolboz Toolbar. Then right click on it and choose Properties and set the Width Property to the cells Column Width and the Height Property to the cell Row Height.

    You can use a CommandButton from the Forms toolbar and size it manualy and set it's Object Positioning to "Move and size with cell". Then Protect the Worksheet to stop the right click action.

  • Re: Button Size as s Cell Size?

    Here's a quick bit of code which resizes a control according to the dimensions of a cell you refer to ...

    Should point you in the right direction

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!