We currently have a .DOTM file in %programfiles(x86)%\Microsoft Office\Office14\STARTUP. When users open Word, the .DOTM file opens in the background and the macros are available when user hits Alt+F8. The .DOTM opens "protected" in a way users cannot edit any of the macros in it.
I want to do the same thing, but in Excel. I created 3 simple macros to open 3 Excel templates. The templates can be opened from File | New | My Templates, but the HR person requesting this, wants to open them via macros. I want to make these Excel macros available to all users in my office by just sharing the .XLTM workbook with them. So, I put the .XLTM file in %programfiles(x86)%\Microsoft Office\Office14\XLSTART, open Excel. When I hit Alt+F8, the macros organizer is empty.
So, I figured I had put the .XLTM file in the wrong folder. I then put it in %Appdata%\Microsoft\Excel\XLSTART. It doesn't work from there either! I googled and found the thing about the PERSONAL.XLSB. I thought, great, just save my macros file as another .XLSB and put it inthe same folder with my other one. NOPE!! Excel title bar now reads "Macros.XLSB" instead of "Book 1." It's opening the .XLSB as a regular file, not "in the background."
All I want is to open Excel and see "Book 1" in the title bar and to get my three macros when I hit Alt+F8. The macros have to be in a different file, not in PERSONAL.XLSB because some users already have custom macros they created. I just want to add these 3 new macros to the pot, like we did in Word. Another reason for having them in a separate file is to make it easy to edit/add macros and deploy them by distributing the file via login script or GPO or something like that.
Can this be done?
I want to do the same thing, but in Excel. I created 3 simple macros to open 3 Excel templates. The templates can be opened from File | New | My Templates, but the HR person requesting this, wants to open them via macros. I want to make these Excel macros available to all users in my office by just sharing the .XLTM workbook with them. So, I put the .XLTM file in %programfiles(x86)%\Microsoft Office\Office14\XLSTART, open Excel. When I hit Alt+F8, the macros organizer is empty.
So, I figured I had put the .XLTM file in the wrong folder. I then put it in %Appdata%\Microsoft\Excel\XLSTART. It doesn't work from there either! I googled and found the thing about the PERSONAL.XLSB. I thought, great, just save my macros file as another .XLSB and put it inthe same folder with my other one. NOPE!! Excel title bar now reads "Macros.XLSB" instead of "Book 1." It's opening the .XLSB as a regular file, not "in the background."
All I want is to open Excel and see "Book 1" in the title bar and to get my three macros when I hit Alt+F8. The macros have to be in a different file, not in PERSONAL.XLSB because some users already have custom macros they created. I just want to add these 3 new macros to the pot, like we did in Word. Another reason for having them in a separate file is to make it easy to edit/add macros and deploy them by distributing the file via login script or GPO or something like that.
Can this be done?