assign macro

Hi all, I have an excel workbook called Bill of Materials (BOM), which contains a lot of macros and I have always had buttons call certain macros. My BOM excel sheet basically uses power query to organize data sourced from a workbook called Masterlist and throws it on a new sheet (on the BOM...

Hello, I recorded a macro just clearing inputs in my file that I'm working with and I've inserted a button onto the sheet and done the 'assign macro' step but it doesn't run my macro. I'm not getting any error or anything, the button does nothing. The macro works if run it from the 'View...

Hi, Wonder if someone can assist, a colleague of mine created a reporting suite where on a main tab we press a button to open a hidden tab and then when we click off it, it automatically closes it, its a great tool, but I need to add a new tab and a new button to open this. Unfortunately my...

Hi, I copied a macro to another module and only changed the sheet name it refers to and now when I go to create a macro button and try to assign a macro to it, it won't let me. I get an error that says 'Reference must be to a macro sheet'. Also, when I open the macro dialogue box, the only...

I'm facing an interesting problem... I have a password protected spreadsheet with multiple tabs. On one of the tabs, there are some radio buttons. I want the radio buttons to have macros assigned to them. When I assign the macro in visual basic modules, the macro works fine but the radio...