Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-05-2013, 06:30 AM
Rapier Rapier is offline custom icon, undo/redo for macro, permanent macro Windows 7 32bit custom icon, undo/redo for macro, permanent macro Office 2010 32bit
Novice
custom icon, undo/redo for macro, permanent macro
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
custom icon, undo/redo for macro, permanent macro How do you undo a macro? ll4u76 Word VBA 6 03-22-2012 02:01 PM
custom icon, undo/redo for macro, permanent macro 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


All times are GMT -7. The time now is 01:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft