macro button

  1. M

    Emailing Workbook with macro button - HELP

    I have an excel workbook (2007) that has a macro that will clear the contents of a sheet. I have that macro assigned to a button on that sheet. I also assigned a keyboard shortcut to the macro. it works fine on my machine and when I email it to anyone inside my company. However, when I email...
  2. R

    Can a chart also be a macro button?

    Hi All, I'm using many small charts on a single worksheet to display information to the client. I would like to make this more interactive, ideally with the user being able to click on a chart and be taken to a worksheet containing more detailed data. I think that the question is then...
  3. T

    copy macro and change row

    Hey all, I have a macro button at the end of a row that copys and reorganizeds the cells in that row to another sheet for printing. Is there a way that I can copy this action down one row? I have a large database and would like to copy these buttons and macros to the end of each row.
  4. J

    Help! Macro to delete/cut row based on specific word in column, and paste the first blank row in another worksheet!

    Hi there everyone, I am new with excel and currently using excel 2003 and I have been asked by my manager to create an action item list and would appreciate anyones help! I've searched through the forums and I cannot find anything that will help me! What I need is a macro code/button that...
  5. E

    Macro for updating a cell on a value match

    Hi, I have used excel for real basic stuffs hence very new to macros and such stuffs.. I ll describe my requirement in brief: I have a 'name' field (person entry) and 'count' field (score) in the below format in Worksheet1: Name Count ----- ------ abc 5 def 10 xyz 10 In Worksheet2, I have...
  6. R

    Pasting macro for skipping blank cells

    Hi everyone. I'm having a bit of trouble with a macro I'm using to select certain info. I don't know much about VBA but I copied a couple old macros I previously had and I've modified them to try and suit the application. It didn't work for me though. (failed miserably actually) I'm doing up a...
  7. H

    Assign macro issue

    I'm running a macro on Excel 2003 and assigned it to a toolbar button via the standard "Assign Macro" form. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> This macro, in order to save the results of all the processing and not affect the original...

    auto colour on search?`

    Hi all i just wanna know is it possible to have a vb script or macro that will enable me to do a search for say a number where the number will be in column A on sheet 1 and then when the number is found that whole row will be coloured in say yellow or something? i work with these bloody long...
  9. E

    Macro Button

    I have a button on a worksheet that performs a task. I want to be able to prevent the user from clicking the button, i.e. disable the button, until they have completed certain cells on the sheet. Is this possible? Thanks in advance Steve
  10. L

    Custom Ribbon Button and Macros

    I have a macro which I assigned to a custom butoon in Excel 2003. This macro was run by many users in my organization. I would like to duplicate the funcationality in Excel 2007. I have created the xml code to add a custom button to the Ribbon using the CustomUI Editor. This works well. I...
  11. L

    Universal Macro

    I recently got a macro button up and running that can pull all the data I need for one workbook (9 different sheets) and be placed on the first main sheet. I was wondering how/if you can make a button from one workbook that updates all the others (or at least some of them). The post is at this...
  12. M

    Disable button when there is a error

    Greeting, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have a macro assign to a button. The button is labeled “Done” and the Macro sub is called “Sub Save_Final()”. The button is placed in sheet1 cell J20. When there is an error on the worksheet, I...
  13. H

    CommandButton vs Form Button

    I want to run a macro from a button on the spreadsheet. I see ther are 2 ways to add a button to the sheet - the CommandButton on the Control Toolbox Toolbar and the Button on the Forms Toolbar. Are there any advantages to using a CommandButton or a Form Button?
  14. 5

    Find Name in spreadsheet

    Hi there, I have a worksheet for each employee along the bottom in my workbook. I would like to be taken to this worksheet when the name has been selected by a drop down list <TABLE style="WIDTH: 308pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=410 border=0...
  15. 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.
  16. 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...
  17. 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...
  18. 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!
  19. 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...
  20. 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?

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...