Discussion on:

How to create macro buttons in Excel and Word

I am interested in getting a certificate, diploma or degree in Instructional Design to advance my career. What are the highly rated schools or training centers for this field? Where are they located?

How do you create a macro in PowerPoint that will change the sentence case (e.g., Format/Change Case/UPPERCASE)? I tried but it doesn't seem to work.

I was able to create a macro in PowerPoint that changed the case by highlighting (selecting) some sample text before I started recording the macro. I then only recorded the actions of Format/Change Case/Uppercase. Let me know if that helps!

This isn't working for me, either. If I highlight ten characters of text before I create the macro, then the macro only works on the first ten characters when I run the macro. What am I doing wrong?

Beth had the right approach. Only when I tried it all my characters within a text box were effected. Looking into the VB help dialog allowed me to determine that the macro recording recorded too many properties, so I removed some and ended up with the following result.

Just cut and paste the following code over the recording that you made earlier. Regards, Marc

Sub UPPERCASE()
ActiveWindow.Selection.TextRange.ChangeCase Type:=ppCaseUpper
End Sub

I have had no success in creating this code as a macro. What are the steps to have this code created as a macro?

I have a number of macros and associated buttons on my computer, but have had mixed results when trying to transport them to another computer. I'd like an article on how to do it.

I can create the toolbar, assign the macro to a button and save the template. However, the place the macros get stored is in a personal.xls on the C: drive. So when I share the workbook the button on the toolbar refers to a macro located locally and errors out when the person sharing it from the PC where it was not created tries to use it. How can this be avoided? Thanks!

Here is another easy way to make a Macro Button and to add a little pizazz to your spreadsheet:

Create and save your macro in Excel.
Open the worksheet.
Insert a picture from ClipArt or from file (or use an Autoshape)
Right click on the picture
Choose Assign a Macro
Find the Macro that you just saved
Click OK

Highlight the cells that you want to use the macro on and click on the 'picture button'. The pointer will change into a hand.

If you need to edit the button, right click again on the image.

I followed the steps listed, but the next time I opened Excel, the custom button was no longer in the toolbar. Any suggestions?

4/30/2008:

Thank you for this useful article: use of macros can expedite the documents I prepare for submission to regulatory authorities (e.g., FDA). I would appreciate learning of analogous articles,

Angus McLean

4/30/2008:

I was successful with a simple macro "?C". I have an icon up there for ?C (degrees Centigrade). I recorded this macro in the usual way by recording the individual steps.

Now when I did the same for trying to establish a macro for paste special, unformatted text I was not successful. The steps for recording the macro involved clicking on "edit"; "paste special" and then selecting "unformatted" text. Now when I use the macro the text I get is still formatted. In other words all I am achieving is copy and pasting the formatted text. I have repeatd this work anotehr 2 occasions and I get teh same result.
PLease can sooemone advice me what I am doing wrong;

Thank you;

Angus

301-869-1009

This document was extremely helpful

Have tried to create Macro buttons to work within a web file but they aren't active, i.e. you can't click them. Guess this may have to do with a security option?

Your article is write very well, I like it very much I wish you have a wonderful day!Thank you.

Hello
I followed your instructions to the letter and the macro buttons are a great time saver. However, when I click on either one of the buttons in the current spreadsheet, as well as running the macro the spreadsheet in which I first created the buttons loads. I just cancel it but it's got me puzzled. Any ideas?