lock commandbutton

  1. S

    Locking CommandButton in UserForm in VBA

    Hi Everyone. I am trying to write a VBA code where the UserForm resizes dynamically depending on values retrieved from cell counts. I have worked that out but I need to have the CommandButton locked to the lower right-hand corner of the UserForm so that it can easily be clicked once the data...
  2. E

    Need help to lock/unlock multiple sections of a worksheet as when clicked by user

    Hi guys, I am an excel savvy person, but not too expert like VBA or macro programmers. As such, I need some help on figuring out how to lock certain portions of my worksheet upon a click of a button. Imagine a 30-day calendar spread page. I need to have 30 buttons which will enable the user...
  3. M

    command button disable userform

    Hi, I am a novice and any help would be appreciated (ive been working on this for 2 days) I have a book that is going to be used to track sales. Currently It works awesome and I have a simple userform that has 4 text boxes and 2 combo boxes. Also it has 3 command buttons (one to save the data...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top