Hi Wansley,

Welcome to our forum!

You haven't attached your file or code, so I can't check it. However, if you want to toggle highlighting of cells on/off, you can use Conditional Formatting for this as explained here.

Mynda

Hello Mynda,

Sorry about that. I've attached it now. Let me know if you see anything wrong with the code. 

Hi Wansley,

You have code in the workbook which is not mine:

Private Sub Workbook_Open()

   If GetCodeSetting("CodeSetting") = False Then Exit Sub
   SetCodeSetting "CodeSetting", True

End Sub

The line in red is generating an error because it's expecting a Boolean (False or True) value but it's calling a Sub that returns a string.

If I comment out that line the code works as it should.

There are a number of Subs and Functions in the workbook that I am not familiar with (I did not write them) so I don't know if you intend for them to be used or not?

If you don't need them I can get rid of them and get the code working for you.

Regards

Phil

Hello Phil,

I don't mind them being removed as long as i'm able to disable and enable the macro. 

Thank you in advance.

Best,

Wans

Hi Wansley,

Please see attached.

Do you want to be able to turn off highlighting on a per sheet basis or for the whole workbook at certain times?

Regards

Phil

Hi Phil,

I would like to be able to turn it off/on for the whole workbook.

Best,

Wans