+ Reply to Thread
Results 1 to 2 of 2

Outline Border Shortcut, changeing the properties

  1. #1
    Registered User
    Join Date
    07-16-2007
    Location
    San Francisco, CA
    MS-Off Ver
    2010
    Posts
    93

    Outline Border Shortcut, changeing the properties

    HI All, I was wondering if any one as been able to change the property of the Outline Border shortcut.
    I would like it change the line weight to medium and change the color to blue.
    the short cut key stokes are: Ctrl + Shift+ 7

    Thanks
    James

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,135

    Re: Outline Border Shortcut, changeing the properties

    Here is a vba solution that will replicate the current Ctl Shift 7. To make this available in all worksheets, you will need to create a personal.xlsb macro sheet. Look at this link on how to do that.

    http://www.rondebruin.nl/win/personal.htm

    Please Login or Register  to view this content.
    How to install your new code
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Choose Insert > Module
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

    To run the Excel VBA code:[list=1][*]Press Alt-F8 to open the macro list[*]Highlight the macro and select Options, then make the macro Ctl Shift 7 in the box.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 12-09-2011, 07:32 PM
  2. Replies: 2
    Last Post: 01-30-2011, 03:21 PM
  3. rename macro in properties window loses shortcut
    By farmerdave in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2008, 07:54 PM
  4. Change cell border & outline in a macro
    By namz in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-07-2008, 03:59 AM
  5. Outline/border Macro
    By James_SF in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-24-2006, 01:22 PM
  6. Replies: 2
    Last Post: 06-20-2006, 12:45 PM
  7. [SOLVED] Is there a keystroke shortcut to Group and Outline in Excel?
    By jocapo in forum Excel General
    Replies: 2
    Last Post: 04-19-2006, 08:20 PM
  8. [SOLVED] Conditional Format - Outline Border
    By Drahos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2006, 05:50 AM

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