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
Bookmarks