开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜