I have an excel workbook that is used by multiple users and they need to be able to do things like making font bold or changing the color of the font, but I don't want them to be able to change the color formatting for the cells themselves. I've looked at locking/protecting the sheets but we use the rest of the formatting on a daily basis. Can anyone help me with a VBA or something that would simply disable or hide the fill color option?
Thanks
Hi, welcome to the forum.
Windows 10 is not an MS-Off version, you should correct that in your profile.
Aside from that I'm almost 200% sure that that's not possible.
You could try something with conditional formatting to set the formatting to no fill, you might need a condition too that could be cell not empty and the entire range the users work in as target range, just an idea but maybe that would do the trick
A VBA option is also on selection change check that if a fill corol is used then reset it to xlNone , so if target fill is not xlNone set it to xlNone
Play around with this
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Thanks, I misread what it was asking for with the MS-Off version. I'm going to blame not enough coffee or frustration at having stared at my screen for too long trying to figure this out on my own. Maybe both.
I'll try working on the conditional formatting route and see if I can figure anything out that way.
Thanks for the advice.
Possibly by adding this to the worksheet's code module
Please Login or Register to view this content.
@dangebor: that's the macro idea, great and simple
I was able to get the Conditional Formatting to do what I wanted.
Thanks for all the assistance.
Great, don't forget to mark the post SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks