VBA code to assign color to an active worksheet

		Microsoft Office Forums > Microsoft Excel > Excel Programming
VBA code to assign color to an active worksheet

FAQ

Thread Tools

Display Modes

03-02-2017, 02:36 PM

jane.bugai jane.bugai is offline

VBA code to assign color to an active worksheet

Windows 8

Office 2010 64bit

Novice

Join Date: Feb 2017

Posts: 5

VBA code to assign color to an active worksheet

Thank you so much for your reply! It worked but I think I didn't explain my question correctly.

I would like the active tab itself to change the color, not the entire worksheet. If that makes sense. In excel, all tabs are white by default and I want the tab I am currently in to change color from white to red. And if I move to another tab, then new tab becomes red and the old one is white again.

Thank you in advance!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Inserting Calendar Control Active X Controls on Worksheet	BillCPA	Excel Programming	0	02-18-2016 10:10 AM
Excel - Color Worksheet Tabs	avie layne	Excel	4	11-12-2012 04:45 PM
If color is red then active	ruby_2014	Excel	2	01-09-2012 01:41 AM
Using VBA to change color of a ext box directly on worksheet	Roscoe	Excel Programming	0	11-21-2011 11:42 AM
VB Code in Excel Active worksheet	shakilhyd	Excel	2	05-17-2010 07:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:42 PM.