Reference must be to macro sheet cannot assign macro

[dturgel]

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 thing highlighted is the 'create' button. But, I can step into the macro in VBA and run it and when I press play in VBA it runs no problem - anyone know why I can't assign the macro to a button?

Daniel

 

[My Aswer Is This]

Each module must has a different name. Open up your module and rename it. And then assign your button to this new name.