+ Reply to Thread
Results 1 to 9 of 9

hi guys is it possible via macro that background color changes every day on a excel sheet

  1. #1
    Registered User
    Join Date
    03-07-2012
    Location
    jaipur
    MS-Off Ver
    Excel 2007
    Posts
    50

    hi guys is it possible via macro that background color changes every day on a excel sheet

    i have a sheet in which i have data from a1 to f 200 ... i want a macro which every day changes background color from a1 to f 200 ....if its change in defferent designes it will be great

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: hi guys is it possible via macro that background color changes every day on a excel sh

    give me a list with the colors you want to use.
    Regards,
    Khaled Elshaer
    www.BIMcentre.com

    Remember To Do the Following....
    1. Thank those who have helped you by clicking the Star below their post.
    2. Mark your post SOLVED if it has been answered satisfactorily:
    • Select Thread Tools (on top of your 1st post)
    • Select Mark this thread as Solved

  3. #3
    Registered User
    Join Date
    03-07-2012
    Location
    jaipur
    MS-Off Ver
    Excel 2007
    Posts
    50

    Re: hi guys is it possible via macro that background color changes every day on a excel sh

    hi mate thanks for replying .... you can use any 7 colors for a week which will change everyday randomly any 7 lite colors .....

  4. #4
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: hi guys is it possible via macro that background color changes every day on a excel sh

    Use this in the workbook code page and replace the Sheet1 with the sheet name


    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-07-2012
    Location
    jaipur
    MS-Off Ver
    Excel 2007
    Posts
    50

    Re: hi guys is it possible via macro that background color changes every day on a excel sh

    thankyou so much , is this code automatically changes the sheet color everyday ???

  6. #6
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: hi guys is it possible via macro that background color changes every day on a excel sh

    yes it does

  7. #7
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: hi guys is it possible via macro that background color changes every day on a excel sh

    Please dont forget to mark the thread as SOLVED

  8. #8
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: hi guys is it possible via macro that background color changes every day on a excel sh

    or
    Please Login or Register  to view this content.
    Last edited by snb; 03-09-2012 at 12:37 PM.



  9. #9
    Registered User
    Join Date
    03-07-2012
    Location
    jaipur
    MS-Off Ver
    Excel 2007
    Posts
    50

    Re: hi guys is it possible via macro that background color changes every day on a excel sh

    thankyou so much indeed

+ 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