How to color the Excel grids of multiple spreadsheets
The code below was found on Google and it is used to color the grids of the spreadsheets.
I would like to know how to apply the VBA command below to spreadsheets 1, 2, 3 and 4 of my Excel project.
However, if anyone has a shorter version of a VBA code to color the grids and can share it, I would be very grateful.
Thank you all!
Please Login or Register to view this content.
File:
Coloring spreadsheets and grids.xlsm
Last edited by JoreXX; 06-29-2025 at 07:48 PM.
Give this a go.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
PERFECT!
Thank you very much
Glad to help.
Shorter is not always better...I almost never make use of activate or select...if anyone has a shorter version of a VBA code
Please Login or Register to view this content.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks