macro button

  1. B

    EXCEL 2007 Macro hyperlink issues

    How can I create a button hyper linked macro that will apply conditional formatting? The cells are positioned vertically in the same column, but not consecutive.
  2. H

    Macro to save to a certain location

    Hi I need to add a save button to a worksheet that will save the first page as a txt file with a username that comes from data within certain cells. Using the following for an example; C7 Joe Bloggs E3 22-02-09 G4 Dr Noone Save location B:\Test_Results\Machine_Results\Dr Noone\Joe...
  3. A

    MACRO Saveas Keeping Current file open ?

    I have the following Macro that I run assigned to a Button. Sub AskAndDo() If MsgBox("Have you Finished collecting data ?", vbYesNo + vbQuestion) = vbNo Then Exit Sub Else If MsgBox("Have you Printed the Reports ?", vbYesNo + vbQuestion) = vbNo Then Exit Sub Else ActiveWorkbook.SaveAs...
  4. J

    VBA code to toggle "XYZ" macro on and off

    Greetings. I have a simple macro assigned to a button on a toolbar. Clicking the button runs the macro which displays two custom toolbars. I want to have the button TOGGLE the macro on and off (thereby turning the two custom toolbars ON and OFF). What's the VBA code? Thanks!
  5. A

    Help with Macros and linked combo boxes

    Hello Folks, I need some assistance with a macro i'm using with linked combo boxes. I have three combo boxes, the first combobox dictates the choices shown in the second combobox and so on. The trouble is that I need to make the coding that I have already, follow on to another 45 combo boxes...
  6. A

    Changing Macro Button Colour

    I was wondering if we can change colour of MACRO BUTTON itself? I can edit the text on a macro button, but can't change the colour of the button itself. By default, it is grey in colour and I want it red. Anybody help?

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
Back
Top