Hi All,

Hope you are well, I have a little issue which for the life of me cannot get around.



I would like to disable the Format Painter tool hopefully by VBA.

Background:

I have a protected worksheet, but users need the ability to FILL in the cells. However these cells have individual conditional formatting which will get moved around if they decided to use the Format painter tool. Hence my need for them to only have the ability and access to the FILL colour function.
Alternatively, If there is an ability to disable all types of formatting and only solely the FILL Colour function available.

Hope this helps.

Thanks for your help in advanced.