command button disable

  1. M

    Disabling macros/command buttons when a cell meets a condition

    Hi all, I have a simple macro that is attached to an active x control command button. The macro simply deletes pre-arranged unecessary cells so that a sheet can be printed efficiently: Sub delete_specified_columns() Sheets("Sheet1").Range("B:C,E:F").EntireColumn.Delete End Sub Here is an...
  2. M

    VBA code also clears clipboard

    Hi I have some VBA code that basically checks if there's an error message in cell M58, then display a Command Button "ClearError1" Private Sub Worksheet_Calculate() On Error Resume Next If IsError(Range("M58").Value) Then ClearError1.Visible = True 'Else ClearError1.Visible = False End Sub...
  3. C

    Reducing the width of command button

    Hi, i want o make some command buttons on a sheet with the width 50 and when you move the mouse over to any one the width of that one should increase to 300. when you move he mouse over to the other one the size of the previous one should return to 50 and the new one (now under the mouse) should...
  4. S

    Hide Command Button Until All Sections Are Filled In

    Hi, Bit of a newbie to VB. I have an email facility on a document i am making. However; I would like this button to be either hidden or out of use until all Sections/Cells are filled in fully. I have set it up so that you cannot save or print the document but this one is making me go crazy...
  5. 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