4 Ways to Create a Custom Macro Button in Excel

4 Ways to Create a Custom Macro Button in Excel Macros in Excel can save a great deal of time with repetitive tasks. By assigning macros to custom buttons, you can save even more time by bringing your macro only one-click from execution.
STEPS
METHOD 1 OF 4: EXCEL 2003

1

CLICK TOOLS ? CUSTOMIZE.

2

CLICK THE TOOLBARS TAB.

3

CLICK THE NEW BUTTON.

4

TYPE A NAME for your new toolbar.

5

CLICK OK.

6

CLICK THE COMMANDS TAB.

7

SELECT MACROS FROM THE LIST ON THE LEFT.

8

CLICK AND DRAG THE CUSTOM BUTTON icon from the list on the right to your new toolbar. The new button is represented by a smiley face.

9

RIGHT-CLICK on the newly added button.

10

RENAME THE BUTTON TO YOUR LIKING OR LEAVE THE DEFAULT NAME IN THE NAME: field.

11

CLICK BUTTON IMAGE... and change the image for your button or leave it the same. The Button Editor has controls similar to the Windows Paint program.

12

CLICK "ASSIGN MACRO."

13

SELECT A MACRO YOU CREATED FROM THE LIST.

14

CLICK OK.

15

CLICK CLOSE ON THE CUSTOMIZE DIALOG BOX.
METHOD 2 OF 4: EXCEL 2007

1

CLICK THE LITTLE ARROW POINTING DOWN ON THE QUICK ACCESS TOOLBAR.

2

CLICK MORE COMMANDS.

3

SELECT MACROS from the CHOOSE COMMANDS FROM list box.

4

SELECT YOUR MACRO FROM THE LEFT HAND COLUMN AND CLICK THE ADD BUTTON.

5

SELECT THE MACRO THAT YOU JUST ADDED FROM THE RIGHT HAND COLUMN AND CLICK THE MODIFY BUTTON.

6

CLICK THE BUTTON IMAGE YOU WANT TO REPRESENT YOUR MACRO, TYPE THE DISPLAY NAME YOU WANT IN THE DISPLAY NAME text box and click the OK button.
METHOD 3 OF 4: EXCEL 2010

1

MAKE SURE THE DEVELOPER TAB IS DISPLAYED. The Developer tab is a tab in the Ribbon at the top of Excel. If it is not displayed, follow these directions in order to display it:
Click File ? Options ? Customize Ribbons
Find the Developer check box in the Main Tabs section and click it. Press "OK" when you are done.

2

IN THE DEVELOPER TAB, CLICK ON THE BUTTON ICON. The Button icon is under the Controls group in the Developer tab and looks like a rectangular button.

3

PLACE YOUR BUTTON. Place your cursor where you'd like the button to go and drag to select the size of the button. You can make the button as small or as large as you'd like, given your needs.

4

ASSIGN A MACRO WHEN PROMPTED. Excel should automatically prompt you to assign a macro to your button after you finish placing it. Once you've selected your macro, click "OK."
If you are unfamiliar with what macros are or how to record them, read more. You should have a macro already built before you create the button.

5

FORMAT THE BUTTON. Right-click on the newly-created button and select "Format Control." Select Properties ? Don't move or size with cells ? OK. This helps you maintain the size and placement of your button. If you don't have this property chosen, your button size and placement will change if you have it add, delete, or move cells.

6

RENAME THE BUTTON. Change the text in the button to say whatever you'd like it to.
METHOD 4 OF 4: EXCEL 2013

1

MAKE SURE THE DEVELOPER TAB IS DISPLAYED. The Developer tab is a tab in the Ribbon at the top of Excel. If it is not displayed, follow these directions[

1

] in order to display it:
Go to Excel ? Preferences ? Ribbon (Under Sharing and Privacy)
Under Customize, check the box next to the Developer tab, and press "OK"

2

CLICK ON THE DEVELOPER TAB AND CLICK BUTTON. The Button icon is under the Form Controls group in the Developer tab and looks like a rectangular button.

3

PLACE YOUR BUTTON. Place your cursor where you'd like the button to go and drag to select the size of the button. You can make the button as small or as large as you'd like, given your needs. If you wish, you can move the button around after placement.

4

ASSIGN A MACRO WHEN PROMPTED. Excel should automatically prompt you to assign a macro to your button after you finish placing it. Once you've selected your macro, click "OK."
If you are unfamiliar with what macros are or how to record them, read more. You should have a macro already built before you create the button.

5

FORMAT THE BUTTON. Right-click on the newly-created button and select "Format Control." Select Properties ? Don't move or size with cells ? OK. This helps you maintain the size and placement of your button. If you don't have this property chosen, your button size and placement will change if you have it add, delete, or move cells.

6

RENAME THE BUTTON. Change the text in the button to say whatever you'd like it to.
TIPS
Try using the 2003 method for Excel versions earlier than 2003.
Alternatively, you may add your macro button to an existing toolbar in versions 2003 and earlier.
If you prefer, it will let you assign a shortcut key in the dialog box. This can prevent wrist strain and save time.
WARNINGS
The user interface on versions earlier than 2003 may be different so the 2003 method may not be exactly the same for those versions.
If you want a different button image than what version 2007 offers, you will need to download additional software that specializes in modifying user interfaces for Microsoft Office.

How to Delete All Contacts on an iPhone: 5 Steps (with Pictures)

Use the Settings app to remove all of the contacts stored on your iPhone.
STEPS

1

TAP THE SETTINGS ICON ON YOUR IPHONE’S HOME SCREEN TO LAUNCH THE SETTINGS APP.

2

TAP MAIL, CONTACTS, CALENDARS.

3

TAP THE NAME OF THE ACCOUNT YOU WANT TO DELETE THE CONTACTS FROM.

4

SET THE SWITCH NEXT TO CONTACTS TO OFF.

5

TAP THE DELETE FROM MY IPHONE BUTTON.
VIDEO

TIPS
If you have multiple accounts that sync contact information to your iPhone, follow the same process to turn off contacts for them in order to remove all contact information from your iPhone.
WARNINGS
Make sure that you have a backup of your contacts stored on another device if you want to access the contacts again once they have been deleted. You can store a backup by turning on iCloud backup or syncing your iPhone with iTunes

How to Jailbreak a 1.1.3 iPhone: 14 Steps

Is your iPhone becoming just another phone? Revive it with this tutorial.
STEPS

1

DOWNGRADE YOUR FIRMWARE TO VERSION

1

.

1

.

1

. To do this you need to download the firmware at "http://appldnld.apple.com.edgesuite.net/content.info.apple.com/iPhone/06

1

-3883.20070927.In76t/iPhone

1

,

1

_

1

.

1

.

1

_3A

1

09a_Restore.ipsw"

2

NEXT, HOLD DOWN THE "POWER" BUTTON AND THE "HOME" BUTTON FOR 10 SECONDS, THEN RELEASE THE "POWER" BUTTON AND HOLD THE "HOME" BUTTON FOR 10 MORE SECONDS.

3

CONNECT YOUR IPHONE TO ITUNES.

4

ITUNES SHOULD SAY IT HAS DETECTED AN IPHONE IN RECOVERY MODE. Then click on the "Restore" button while holding the shift key.

5

A WINDOW SHOULD POP UP. Then, find the 1.1.1 firmware you downloaded earlier and select it.

6

WAIT WHILE IT UPDATES.

7

THEN, ON YOUR IPHONE, GO TO "SAFARI" INTERNET BROWSER, GO TO WWW.jailbreakme.com

8

GO ALL THE WAY DOWN TO THE BOTTOM AND CLICK ON "INSTALL APPSNAPP"

9

WAIT UNTIL IT IS DONE.

10

THEN YOU NEED TO DOWNLOAD "IBRICKR". You can find it at "http://cre.ations.net/blog/post/iphone-113-jailbreak-released"

11

THEN, OPEN IT WITH WINZIP AND "EXTRACT" THE FILE CALLED "IBRICKR"

12

NEXT, CLICK ON THE EXTRACTED FILE.

13

FOLLOW ALL THE INSTRUCTIONS.

14

CONGRATULATIONS! You have now jail broken your iPhone!
VIDEO

TIPS
Beware that you will need to "jailbreak" your iphone to download 3rd party applications. Be sure to 3G iPhone unlocking properly.
Don't let the above steps intimidate you. This method is much harder and rarely used today. Just install ZiPhone ([www.ziphone.org]) and let it do all of the work for you.
WARNINGS
This will void your warranty with Apple
This will also work with an iPhone version 1.1.4.
This will erase everything on your iPhone
ZiPhone ([http;//www.ziphone.org]) has a tool that lets you easily jailbreak, activate, and unlock your iPhone in one click of a mouse! This is better and more user friendly than iBrickr.
THINGS YOU\'LL NEED
An iPhone
A Computer
The Internet
WinZip

How to Compliment a User on the Yelp for iPhone App for a Review they Wrote

Did you just notice a review that expressed your own true feelings of the business while researching through the Yelp for iPhone app? With this article, you will learn how to compliment on a user's review on a job well-done.

This article would benefit from screenshots.
You can help wikiHow by reading Take Screenshots for wikiHow for instructions. Notice added on {{{date}}}.
STEPS

1

POWER ON AND UNLOCK YOUR IPHONE. Type in your 4-digit pin (if you have one set up).

2

DOWNLOAD AND INSTALL THE YELP FOR IPHONE APP FROM THE APPLE APPSTORE (IF YOU HAVEN\'T DONE SO ALREADY).

3

LOGIN TO THE YELP FOR IPHONE APP, WITH YOUR YELP CREDENTIALS, IF YOU HAVEN\'T DONE SO ALREADY.

4

SEARCH FOR THE BUSINESS\' REVIEW YOU\'D LIKE TO COMPLIMENT THE USER ON, FROM THE SEARCH BAR AT THE TOP OF THE APP.

5

TAP THE BUSINESS YOU\'D LIKE TO VIEW FOR THE REVIEW.

6

SCROLL DOWN UNTIL YOU GET TO THE SECTION ENTITLED "REVIEWS".

7

TAP A REVIEW, OR, IF THERE ARE MORE REVIEWS THAN JUST THE TOP 4, CLICK THE BUTTON SLIGHTLY BELOW THESE TOP 4 LABELED "(X) MORE REVIEWS" (WHERE X DESIGNATES HOW MANY ADDITIONAL REVIEWS ARE PRESENT).

8

READ THE REVIEW FROM THE VERY TOP TO THE LAST WORD.

9

TAP THE COMPLIMENT BUTTON FROM BELOW THE VOTING BUTTONS

10

FLICK THROUGH THE LIST THAT IS DISPLAYED, UNTIL YOU FIND THE RIGHT OPTION THAT BEST DESCRIBES YOUR COMPLIMENT.
Your choices are: Thank You, You're Cool, Hot Stuff, You're Funny, Write More, Good Writer and Just a Note).
The defaults for the compliment's messages are as follows:
_Thank You_ will default to: "Gracias. Merci. Arigato. Danke... There aren't enough languages in the world to express my gratitude."
_You're Cool_ will default to "You're so cool you make me want to stop, collaborate and listen."
_Hot Stuff_ will default to "You're hotter than a campfire, and I want me s'more."
_You're Funny_ will default to "I think I LOL'd my pants!" (verbatim)
_Write More_ will default to: "In the words of Oliver Twist...Please sir, I want some more."
_Good Writer_ will default to: "You've got the write stuff, baby!"
The _Just a Note_ compliment will not default to any special message. You can create one of your own, after you select this item.

11

TAP INTO THE "SEND LINK AND TYPE A MESSAGE TO PERSONALIZE THE COMPLIMENT" OPTION, OR LEAVE THE DEFAULT NOTE AS-IS.

12

TAP THE "SEND" BUTTON WHEN COMPLETE, FROM EITHER BELOW THE MESSAGE BOX, OR FROM THE TOP RIGHT CORNER OF YOUR SCREEN.
TIPS
First time writers of written words in the business community section, please be sure to read the Talk page guidelines before submitting any talk page messages to the site.
You can find the exact types of compliments you've received on your full-Yelp profile page. The Yelp homepage, once you've signed in, will display just the total number of compliments you've received, and it will also tell you when you receive a new compliment.
Each compliment has it's own compliment icon. Try to learn them all, when you begin to send compliments to authors.
WARNINGS
You cannot send a compliment to yourself on your own reviews. That is totally impractical to do, and is not something they developed into the system, so you'll know you've stumbled upon one of your own reviews, when you read the business page and see one without the compliment button.
At the present time, you can only compliment a user on any of their uploaded pic and lists on Yelp website. There is no functionality on the iPhone app yet.
THINGS YOU\'LL NEED
iOS device
Yelp app
Yelp account
Yelp friends (optional)
Yelp reviews to compliment on

How to Improve the Reception on an iPhone 3G: 7 Steps

How to improve the reception on the new Apple iPhone 3G—No hacking or hardware changes required
STEPS

1

TURN ON IPHONE AND CHECK CURRENT SIGNAL STRENGTH.

2

GO TO "SETTINGS".

3

TAP ON "GENERAL".

4

TAP ON "CELLULAR".

5

UNDER ENABLE 3G, SLIDE IT TO "OFF" SETTING.

6

GO BACK TO HOME SCREEN AND WAIT FOR 2 MINUTES.

7

CHECK THAT THE SIGNAL HAS IMPROVED.
TIPS
Great for battery life.
You can easily revert back and enable 3G.
Don't cover the bottom portion of the phone with your hand when holding it.
WARNINGS
Only use if you do not required the GPS and 3G surfing speeds

3

G will be turned off.
THINGS YOU\'LL NEED
iPhone 3G

How to View PDF Files on an Android Phone: 5 Steps

Android phones are basically the new hand-held computers that you can carry around in your pocket. That being said, there is nothing more frustrating than trying to download something from an email, and being unable to do it. To safeguard against that horror, it's important to enable your phone to view PDF files. Here is wikiHow to view PDF files on an Android phone.
STEPS

1

GO TO THE ANDROID MARKET APPLICATION ON YOUR PHONE AND ENTER IT.

2

GO TO THE SEARCH BAR AND TYPE "ADOBE READER" AND THEN SEARCH FOR THAT.

3

THE APPLICATION "ADOBE READER" SHOULD SHOW UP.

4

DOWNLOAD THE APPLICATION.

5

AND NOW YOU SHOULD BE ABLE TO READ PDF FILES! But you must have a file browser to actually see the PDF files. The "Adobe Reader" application is not an open-able application. As in, you cannot open the application by itself and then choose a file, you must choose the file first, and if it happens to be a PDF, you are now able to read it!

How to Play Game Boy Advance Games on an Android Tablet: 12 Steps

An article about how to play Gameboy Advance games on you're Android Tablet. If you've wanted to play old gameboy advance games on you're tablet then this is how.
STEPS

1

GO ONTO YOUR ANDROID INTERNET BROWSER.

2

TYPE IN "4SHARED" ONTO THE SEARCH BAR.

3

ONCE ON 4SHARED TYPE IN "GAMEBOID".

4

YOU SHOULD GET A LIST OF THEM, CLICK ANYONE THERE.

5

YOU SHOULD SEE A TIMER COUNTING DOWN WHEN IT REACHES ZERO YOUR DOWNLOAD SHOULD BE THERE.

6

WHEN YOU\'VE DOWNLOADED IT, GO BACK ONTO 4SHARED AND TYPE IN "GBA BIOS.bin or gba bios.zip" which is required to play any game (Repeat step 4-5)

7

OPEN UP GAMEBOID AND IT SHOULD SAY SOMETHING LIKE "OPEN BIOS.bin"

8

IT SHOULD GIVE YOU AN OPTION TO OPEN YOU\'RE FOLDER SO DO THAT AND OPEN FILE "SD CARD" THEN OPEN "DOWNLOADS" AND A FILE BIOS.bin should be there, press that.

9

IT SHOULD NOW SAY "NO ROM LOADED. Press menu for more options" at the bottom of the screen it should say "Load ROM" and "Search ROM" if you already downloaded a GBA ROM then press "Load ROM" and then go into SD card and downloads again and it should be there

10

IF YOU DON\'T HAVE ONE PRESS "SEARCH ROM" AND THEN TYPE THE NAME OF GAME AND SELECT GBA IT SHOULD GIVE YOU A LIST OF AVAILABLE ROMS CLICK ONE TO DOWNLOAD AND THERE YOU GO (REPEAT STEP 9)

11

YOU SHOULD NOW BE ABLE TO PLAY ANY GBA GAME FOR FREE ON YOUR TABLET

12

ENJOY!
TIPS
"Start" "Select" and the directional buttons are already on screen
Seems as the tablet has no keys to press A or B go into settings then key settings and press A and B and put the short-cut as Volume up and volume down and make what ever the short cut for volume up and down were as nothing(press clear)
It's the full version for free as most paid things on 4shared are free
WARNINGS
Most ROMS are illegal to download if you don't own a copy of the game. So read up on it before hand