+ Reply to Thread
Results 1 to 6 of 6

Highlight rows.

  1. #1
    Registered User
    Join Date
    07-16-2012
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    35

    Highlight rows.

    Hi there,
    I use code on my spreadsheets that highlights the current row i have selected (code below). This has to be added into the worksheet that i want it applied to. if i add it in as a module for the workbook or into personal.xlbs it wont work. is there anyway to adjust this so it will work for any spreadsheet i open?

    Any help would be greatly appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Highlight rows.

    Hi vtxvtx,

    You could try:

    Please Login or Register  to view this content.
    in the Workbook.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    07-16-2012
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Highlight rows.

    Thanks, that works great for the whole workbook (with a little adaption to clear the highlights from all worksheets when you turn it off)

    However, is there a way to add this to personal.xlsb to allow it to work on any workbook that im using or is this impossible? i don't know much about how personal.xlsb works really.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Highlight rows.

    I don't know about the .xlsb files, are they still in developement and I don't know why you'd want to zip a personal file anyway - can you change it to xlsm??

  5. #5
    Registered User
    Join Date
    07-16-2012
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Highlight rows.

    I can't see anyway of changing it for that file. It's the personal macro workbook created by excel by default. its not of my own creating.

    I'm basically wanting to get the stage so i can have the highlight_on and highlight_off attached to the excel toolbar, so i can use them to turn the highlight function on for whichever workbook i happen to open, without first having to add the code to it. so any method of getting to this stage would be fine by me, it just seemed that personal.xlsb would be the way forward.

    thanks
    Andy

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Highlight rows.

    I can change mine - the Save As option is available for the personal book for my 2003!

+ 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