+ Reply to Thread
Results 1 to 3 of 3

Wrap Text Macro

  1. #1
    Registered User
    Join Date
    07-18-2008
    Location
    Australia
    Posts
    40

    Wrap Text Macro

    I added a shortcut Button using a Macro on the Menu Bar on Word Wrap (Format > Cells > Alignment > Tick Wrap Text). However, that button is working only on the Workbook I created. When I created the macro, I did not have the option of putting it in "Personal Macro Workbook"?

    How can I make that button work on all Worksheet I operate in Excel from now?

    Thanks in advance for your cooperation. Cheers!
    Last edited by nsd3; 09-22-2009 at 11:08 PM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Wrap Text Macro

    As found in http://personal-computer-tutor.com/personalxls.htm

    How to create a macro *template* to store macros to be available in all workbooks:
    You can create a worksheet to hold all the macros and have that worksheet always run when you open Excel. To do this, run Windows Explorer and go to C:\Program Files\Microsoft Office\Office\Xlstart (assuming you used the default location when you installed Office).

    Right-click the right pane of Xlstart and choose New, Text Document. Name your new document personal.xls and press Enter. When asked if you want to change the extension, click Yes.

    Now double-click your new file to open it in Excel. Next, choose Window, Hide and then choose File, Exit. When asked if you want to save the Personal macro workbook, click Yes. The next time you run Excel, personal.xls will run but remain hidden.

    To store your macros in personal.xls, choose Window, Unhide to unhide personal.xls. After you finish storing your macros, choose Window, Hide to hide personal.xls again.

  3. #3
    Registered User
    Join Date
    07-18-2008
    Location
    Australia
    Posts
    40

    Re: Wrap Text Macro

    EXCELLENT!!!!

    Solved in 10 Minitues!!

    Thanks heaps!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1