VBA to change black automatic font color for future entries

data808

Active Member
Joined
Dec 3, 2010
Messages
353
Office Version
  1. 2019
Platform
  1. Windows
Does anyone know how to change the default black automatic font color using VBA? I would like to do this so that the user can type in all future cells with the color red as the font color until they decide to change it back to black. Could not find anything online to do this simple yet seemingly impossible task. I hope someone out there knows how to do this or at least a workaround. Thank you in advance.
 
I have no idea why it doesn't work for you.
If you want to upload the file to a file sharing site and provide a link to it in this thread, I will take a look at it when I have a chance.
I figured out the problem @Joe4. It's the protection of the sheet that screws it up. It needed an Activesheet.Unprotect line in the change event for it to be able to change the font color and then of course lock it back up with the Activesheet.Protect line. I can't believe I missed that. Thank you very much for the help @Joe4.
 
Upvote 0

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,213,538
Messages
6,114,218
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top