Hello everyone,
I have put together the below code:
I would like it to be applied only to sheets named in "DD.MM" format
Please Login or Register to view this content.
At the moment it works but because i pasted the code on each sheet; i want it to be in a module only.
I would also like the text in "I6:i90","l6:l90","o6:o90" to be white. (girly stuff, looks nicer)
can you please help?
thank you in advance
Last edited by annazet; 09-14-2018 at 08:39 AM.
You can put your code in the ThisWorkbook module with the updates shown, and add the initial line of code shown, and qualify your range references as shown.
I have not tested this but would be happy to do so if you provide a sample file.
Please Login or Register to view this content.
Thank you, tried applying the changes but i get an error with an indication on
Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Try this, and remember it goes in the ThisWorkbook module.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Amazing ! Thank you xxx
wanted the text to be white as well but can live without it; dont want to impose to much.
THank you Jazzer and Nori
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks