i have odd issue single command button refusing run macro attached. message "cannot run macro "". macro may not available in workbook or macros may disabled."
i have 3 buttons created code on new sheet , macros assigned. first 2 buttons work third not. if re-assign same macro button (right click - assign macro) works fine not accomplish need.
all macros etc have been enabled. hope can help, doing head in!
sub addbutton() dim buttonname1, buttonname2, buttonname3 string activesheet.buttons.add(200, 5, 81, 36).select buttonname1 = selection.name selection.onaction = "copyback" activesheet.shapes(buttonname1).textframe.characters.text = "modify scenario (copy back)" activesheet.buttons.add(285, 5, 81, 36).select buttonname2 = selection.name selection.onaction = "gotoplanner" activesheet.shapes(buttonname2).textframe.characters.text = "return shift planner" activesheet.buttons.add(370, 5, 81, 36).select buttonname3 = selection.name selection.onaction = "dellcurrsheet" activesheet.shapes(buttonname3).textframe.characters.text = "delete scenario" activesheet.range("a1").select end sub
apologies if have wasted anyones time on have identified typo causing issue macro name assignment.
