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
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
give me a list with the colors you want to use.
Regards,
Khaled Elshaer
www.BIMcentre.com
Remember To Do the Following....
- Thank those who have helped you by clicking the Star below their post.
- 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
hi mate thanks for replying .... you can use any 7 colors for a week which will change everyday randomly any 7 lite colors .....
Use this in the workbook code page and replace the Sheet1 with the sheet name
Please Login or Register to view this content.
thankyou so much , is this code automatically changes the sheet color everyday ???
yes it does
Please dont forget to mark the thread as SOLVED
or
Please Login or Register to view this content.
Last edited by snb; 03-09-2012 at 12:37 PM.
thankyou so much indeed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks