It all seems strange.

I can press ALT+F11 to access VBA with no problem. When I open a
spreadsheet with macros / VBA code in it, I get the "Security Warning"
window advising of the existence of macros, and the three buttons at
the bottom. Selecting "Enable" allows me to open the file, and use it
as it was intended.

I've contacted our support team, who have no idea why the Tools menu
is disabled. Go figure!

Duncs

On 23 Jul, 16:12, JLatham <HelpFrom @ Jlathamsite.com.(removethis)
wrote:
As Toppers said, without either Excel 2007 or access to VBA/Macros, 3
conditionals are all you are allowd (with 4th default condition as Dallman
Ross noted). Even moving to 2007 may not be the solution IF you are the only
one with 2007 and other people need to use your files. While there are
add-ins from Microsoft for earlier versions of Excel to use to view/use 2007
files, you're going to lose appearance/functionality when someone on another
machine saves it as an earlier version of Excel format.

Perhaps someone needs to review the organization's policy on Tools use. I'm
curious, if you press [Alt]+[F11] what happens? Also, do you know if Macro
Security has been set to High (meaning Only signed macros from trusted
sources will be allowed to run, unsigned macros are automatically disabled),
or Very High: Only macros installed in trusted locations will be allowed to
run. All other signed and unsigned macros are disabled.

Realizing you have to use Tools to get to view the Security level settings,
you may have to ask 'the powers that be' just how macros are handled with
regards to security.

Since the code needed to provide you with multiple conditional formatting
would be attached to the Worksheet_Change event, it may be that you can
somehow make arrangements with those 'powers that be' to enable the feature.
Where there's a will, there's usually a way (or a bunch of greedy relatives).



"Duncs" wrote:
Is it possible to have more than three conditional formats set, in the
"Conditional Formatting" window? If so, how do you do it?

Or, is this the limit and that's that?

TIA

Duncs- Hide quoted text -

- Show quoted text -