#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do you undo a macro? | ll4u76 | Word VBA | 6 | 03-22-2012 02:01 PM |
Generic range for custom sort macro? | tswiers | Excel Programming | 2 | 08-11-2011 02:40 AM |
sort & filter icon not available or icon not highlighted | survivo01 | Excel | 1 | 08-08-2011 03:41 AM |
How do I assign a macro to a button when the macro is in my personal workbook? | foolios | Excel Programming | 2 | 07-27-2011 02:41 PM |
Create Custom menu using a macro | twnty2 | PowerPoint | 0 | 06-29-2011 04:26 PM |