Hello members,

This would be my first post. Until now I've been able to use information from previous post but this one I can't figure out.

I have a workbook which contains named cell ranges. Also in one of those names is a formula in the reference. See attached picture.
2014-11-11_155531.png

I use this name (BevatFormule) in a conditional formatting which work perfectly.

The problem is when I sign my workbook with a digital signature, Excel keep asking to allow macro's on opening the document.
I took a while until I figured out the formula in the name was the problem. Did anyone experienced this before and know a solution for this?

I know I can place the formula directly in the conditional formatting but I want to be able to change to formula/code just on one place instead of in each worksheet.
Also I found that I can make a function in VBA and refer to this name in the conditional formatting but I’m not sure if this would be better.

I hope I described my problem clear enough and within the forum rules.

Thanks in advance.
Michael