However, if I protect the macros as described by Hans, at step 3.b, the macros is not shown in the area under Macros.ĭo you see what I mean? Or do you need me to provide some screen shots?īack to the question of making Add-In: are the above steps correct to create Add-In? If they are wrong, what are the correct steps? But of course a macros can do other sophisticated operations.) (In my example, it just displays a message box. Now, whenever we open any Excel file, the new button will be there and we can use it with the currently open file. Choose the macros from the list and press the Add > button (create a new group if needed) In Choose commands from:, choose Macros and the macros subroutine created in step 1 will appear in the area belowĬ. Display the Add-in as a button in Ribbon:ī. xlam file created in step 1 and enable it.ģ. At the bottom, select Excel Add-Ins in Manage: and pressĬ. ![]() ![]() Click Insert > Module and put in some code, egī. Here below is how I was taught to make Add-In:Ĭ. I'm afraid we're not talking about the same thing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |