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 online now 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,977
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



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 10:12 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