View Single Post
 
Old 08-05-2013, 06:30 AM
Rapier Rapier is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Aug 2013
Posts: 1
Rapier is on a distinguished road
Default custom icon, undo/redo for macro, permanent macro

ICON:
I have made my own excel button icon, in ms paint, for my personal macro.
It is .png format.
When I will be renaming my macro group cart, I will change macro's icon.
I know how add icons into ribbon or into top up window ribbon.
I need to place my file in a location, which will be available to detect by excel icon gallery; so I will be able pick it from popped-up window.
I would like to know
- in which program is proper to make my own excel button icon ? (Ms Pain?)
- which file extension it needs to be to be readable for excel ? (.png?)
- what would be maximum pixel size for icon ? (like 500x500 pixels?)
- where should be placed the icon, to be found by excel and offered me in Ribbon, Quick Access Panels customizations ?


UNDO/REDO FOR MACRO:
Undo/redo button doesn't work with macros. If you want change back macro's activity, you can't. Do I need for this another macro ? If so, please can someone write it for me ?


PERMANENT MACROS:
I have a macro where I'm not sure when I will need to use it.
I need them built into Excel to be able use them at every start of the program – like you would install some add-on (e.g. Kutools).
How can I do it?
I heard there are two ways. Via .xlsb (personal sheet) and via .xlam (add-in)

What is advantages/disadvatages of each and which one use for my case ?








MANY THANKS FOR REPLIES
Reply With Quote