Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2015, 04:01 PM
ddaniels ddaniels is offline Help make Macro Please Windows 8 Help make Macro Please Office 2010 64bit
Novice
Help make Macro Please
 
Join Date: Jan 2015
Posts: 1
ddaniels is on a distinguished road
Default Help make Macro Please

Hello,



I am in need of a Macro in order to help save hours of work in MW.

in outline view of a page, for levels 1 through 7, I need to capitalize the first letter of each word.

The only words that will not be capitalized are: and, to, the, a, an, with, are, in, by, and other words of that nature (I believe prepositions).

Is this possible? If so, I would really appreciate the help as it would save a lot of time and money! Thank you.

I will be posting more macro requests as i learn to create them as they seem to be extremely useful.
Reply With Quote
  #2  
Old 01-13-2015, 05:36 PM
Guessed's Avatar
Guessed Guessed is offline Help make Macro Please Windows 7 32bit Help make Macro Please Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Although a macro would be more re-usable, you could do this without macros relatively quickly if you carry out the following steps.
Change the Outline View and show only headings 1-7
Select all and click the Change Case button on the Home tab to set a capital letter on each word.

It is also possible to do a series of search and replaces for the preposition handling but it is not simple because any heading that starts with a preposition should probably retain the capital for that particular word. However, a search and replace on the selection (don't continue for rest of document) will just do the headings when they are shown and selected in outline view.

Someone might supply a macro to help you out but the above instructions will let you get most of the way there without a macro.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help make Macro Please Need macro to make list of "defined terms" glnz Word VBA 8 09-07-2022 02:09 PM
Help make Macro Please Macro Question: Need help making a macro to highlight the first word in every sentence LadyAna Word 1 12-06-2014 10:39 PM
Help make Macro Please How To make any open sheet in WorkBK run Macro. shilabrow Excel Programming 5 06-23-2014 07:14 PM
Help make Macro Please How to make an add-in/global macro hanvyj Excel Programming 4 12-14-2012 03:23 AM
Help make Macro Please Can I automate or make a macro for this? mkoenig Word VBA 1 01-31-2010 02:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:10 PM.


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