macro button

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...

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...

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!

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...

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?