![]() This is not difficult but it is tedious - in and out of ribbon customise while you see what the latest change has improved or messed up. Your needs might be modest the Gift macros are numerous and my approach to defeating the ribbon is to pack atab FULL of useful tools so that even on my 24" monitor, Excel compresss most to the smallest size. Amend your ribbon to have the hings you need. Check in VBA that the new module is in place. Add the how to and other files needed.Ĭreate the always open in excel folder (c:\my Documents\XLAddins in my case, why change it?) Open Excel. Save the xlsm in a dedicated folder ready for distribution. Now if you really won't use an Addin, OK. I'm amazed that 2010 does not support direct rename of a module. Then in notepad, replace 'module1' in the first line of the. Name the export file the same as the name you want. Hint: to change a module to something meaningful, do remove module and export. xlsm file that does not have any thing else that is not part of the distribution. I start with organising the macros I'll distibute into a module named Gift macros (all file names here are approximate as I'm not on 2010 tonight) and into a. They do have to be consistent - there may be more flexibility but keeping all in line is simplest to manage. ![]() My system is hard coded for 'Gift*.*' files and that's not copyright so you do not have to change it but the places where you would do so are pretty clear in the files. So I use dos level commands to place files wher I need them. Adding addins is another thing that some are afraid of. Mine (unlike others') do not install and uninstall when added. They are also relatively closed and hidden from users. Addins cannot carry sheets freely but they are not wanted for my macros. You can place a file with macros (and sheets) in the 'always load from' folder, and as that it unused in our estate I chose that route. I opine that providing a module or several for peoplt o add to their personal.xls is the simplest but my users did not have a personal.xls and got lost in the very short instruction. Several things there: I found from bitter experience that getting a large bunch of macros onto another user's machine was problematic they had to do the install and like yourself lacked familiarity with VBA editing. (3) How do you get the batch file and Gift 2010setup.bat for the user? Don't you provide the folder of files (in (2) above) to the user and then they open the installer file and click the "Install" button? Then the user restarts the computer and that's it? The author opens the installer file and runs the AuthorOnlyExport macro. (2) Just clarifying: you put the installer file (Gift 2010 Installer v3.xlsm). bas files I have created (ribbon and macros behind the ribbon) such as to installer also? (1) Do I need to change the names of the. Some questions for you based on your "Instruction" page in 'Gift 2010 Installer v3.xlsm': ![]() Unfortunately, I may be one of the individuals who are "faint at heart" sincer I'm not thoroughly versed in VBA and XML. I would prefer not to do the add-ins as they need to be loaded each time the user uses excel and they can create conflicts with other add-ins or mechanisms. Can something similar or better be achieved in excel?īrynbaker, the concept you have suggested is what I am looking for since I need to install the customized toolbar on nearly 50 machines. Once the import is completed, the customized toolbar is fully functional. I have done a similar export and import of a customized toolbar (with macros) in Microsoft Word. Is there a way to do the import without having to do this re-mapping? This can be rectified if I re-map the macros/icons to the toolbar in the new computer but it takes a fair amount of time. However, when I test the imported customized toolbar in the other computer, I get an error message saying that it cannot find the macro (or it is unavailable). The macros are located under VBAProject (PERSONAL.XLSB) in the VBA window in both computers. ".bas file") and imported them both into excel of another computer. For example, one icon will insert a checkmark in the Webdings font type into the selected cell on the spreadsheet. I have created a customized toolbar in Excel 2010 which contains several icons that trigger macros (a set of VBA coding per icon).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |