I was wonder if anybody could explain the difference between the Excell11.pip and Excel11.xlb. I know the 11 means i'm running XL 2003.
The reason i need to know is because i'm trying to build a standardized templete with macro icons for my company's XL users. I've already distributed the macros, but the marcros need to be linked to toolbar icons. I figured the best way to do this would be to distribute a standardized excel templete (most users would be lost trying to link the macros themselves). After some research, I also learned about the .xlb but I also found the .pip and I have no idea what it does (now i feel like one of the user's i described above).
Does the .xlb also control settings in the tools-->options-->general?
What does the .pip do?
Any better ideas to link the macro's to the icons for the 1000's of users?
Does anyone know how to make an additional item in format toolbar (you know the one with File, Edit, View, Insert etc..)? I think this would be another option for distrubtion since I could just add a new drop down to the this toolbar with all the macro's listed.
Thanks for any help and sorry for the mult. questions.
The reason i need to know is because i'm trying to build a standardized templete with macro icons for my company's XL users. I've already distributed the macros, but the marcros need to be linked to toolbar icons. I figured the best way to do this would be to distribute a standardized excel templete (most users would be lost trying to link the macros themselves). After some research, I also learned about the .xlb but I also found the .pip and I have no idea what it does (now i feel like one of the user's i described above).
Does the .xlb also control settings in the tools-->options-->general?
What does the .pip do?
Any better ideas to link the macro's to the icons for the 1000's of users?
Does anyone know how to make an additional item in format toolbar (you know the one with File, Edit, View, Insert etc..)? I think this would be another option for distrubtion since I could just add a new drop down to the this toolbar with all the macro's listed.
Thanks for any help and sorry for the mult. questions.