Jim
Thanks for picking this up. I'm unclear where this macro comes from. As it
doesn't contain any code would you expect I can just delete it?
Thanks for your help
Kevin
"Jim Rech" wrote in message
...
I get the macro warning regardless of the conditional formats.
The reason for it is the macro in the Sheet1 code module. Right click the
tab and pick View Code. It's true that Sub Worksheet_SelectionChange has
no
code in it but the macro virus detection device in Excel doesn't evaluate
the code, it just looks to see if there is any.
--
Jim Rech
Excel MVP
"Kevin Lucas" wrote in message
...
Sorry - I'm using Excel 2003 and I've attached a test workbook that
manifests the problem. My Excel Macro Security level is set to medium.
Thanks
Kevin
"Jim Rech" wrote in message
...
You should always mention your Excel version in a post.
I tried Excel 97 through Excel 2003 and couldn't reproduce the problem.
If
you have a simple workbook that demonstrates the issue you can send it
to
me.
--
Jim Rech
Excel MVP
"Kevin Lucas" wrote in message
...
| I've used conditional formatting based on a simple formula like
=$B6=1.
Now
| Excel warns me of macro viruses and I have to choose whether or not
to
| enable macros before opening this spreadsheet. I'm pretty sure this
formula
| is the cause because I've tested it in a spreadsheet that contains
nothing
| else except the two cells under test (B6 and the cell I'm
formatting).
If
I
| change the formula to a constant and use "cell value is" then the
macro
| warning goes away.
|
| I certainly haven't created any macros in the workbook and if there
were
any
| presumably the warning wouldn't go away when I remove the formula.
|
| Are formulae treated as macros by Excel security? And is there any
way
to
| achieve conditional formatting off formulae (needed to format one
cell
on
| the basis of the value in another) without incurring security
warnings?
|
| While I could change my own security settings I'm not at liberty to
change
| those of colleagues who are using such a spreadsheet and who don't
want
the
| warnings to appear each time the workbook is opened.
|
| Thanks for any ideas you have.
|
| Kevin Lucas
|
|
|