a couple of saved xlsx issues

**cmccabe** · 02-23-2015, 03:31 PM

The attached file is saved using the code below:

VB

Please Login or Register  to view this content.

I have two questions that I can not figure out:
1. How to disable the security warning message
2. Why is there purple highlighting (like in rows 103, 105, 188) when that is not even in the code, am I doing something wrong?

Thank you

.

**davesexcel** · 02-24-2015, 03:29 AM

` ElseIf rw.Cells(iRow, iClassification).Value = "pathogenic" Then _
rw.Cells(iRow, iClassification).EntireRow.Interior.ColorIndex = 9 `
Isn't this the code that colors the row?

What security msg are you getting?