Macro not in the list after loading the add-in
I have a created a macro show() and saved it as display.xla and open a new workbook and added the display add-in. But when i went to Tools->Macro->Macro.. its not the list, But if i type display.xla!show and click run im able to execute it.
Is there anyway to dis开发者_如何转开发play the macros stored in the Add-in.? Apart from having it in personal.xls.
Have you declared the show macro as a function, or have Option Private Module at the start of the head of the module? Either will stop it showing in the macro list.
精彩评论