+ Reply to Thread
Results 1 to 7 of 7

VBA to grey out the remainder of row

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    Leicester
    MS-Off Ver
    Excel 2003
    Posts
    7

    VBA to grey out the remainder of row

    Hi Guys,

    I have been stuck on this problem for a while now and wondering if anyone could offer some assistance.
    I have a sheet with numerours columns, Columns J,N,R & U offer the user the following options: "Withdraw, Reject, Proceed".

    What i'm trying to achieve is that if the user selects "Withdraw" or "reject" the remainder of the row to be greyed out (until column AE).

    Any help would be really appreciated.

    Thanks

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: VBA to grey out the remainder of row

    can you show an example ?
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    09-26-2012
    Location
    Leicester
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: VBA to grey out the remainder of row

    Thank you for your prompt reply. Please see the attached sheet.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: VBA to grey out the remainder of row

    the sheet is empty, how can I see what you want ?

  5. #5
    Registered User
    Join Date
    09-26-2012
    Location
    Leicester
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: VBA to grey out the remainder of row

    really sorry, wrong attachment selected in upload.
    Please see attached.
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: VBA to grey out the remainder of row

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    09-26-2012
    Location
    Leicester
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: VBA to grey out the remainder of row

    absolutely perfect. Thank you so much.

+ 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