"Johnno" wrote in message
ups.com...

If Excel 2007 is the host application, you need to work with the ribbon
rather than with the old commandbars. It's a pain to get started with,
but
its actually pretty easy once you've gotten started.

The charts not displaying issue seems to me (based on non-scientific
analysis, like using my memory) to be a problem with Excel 2003 and
earlier
charts in Excel 2007. I have not personally observed this problem, but
whether I'm good or just lucky I don't know. If the project is completely
upgrading to 2007, just rebuild the charts. If you have mixed users, then
I
have no advice.

The macro security prompts could be a problem in all Excel versions.
There
are tricks to get around them. 'Professional Excel Development' by
Bullen,
Bovey, and Green discusses this issue.

- Jon

Thanks Jon.
Alas, I have mixed users with Excel versions from 2000 to 2007.
The vertical bar charts created with Excel 2000 display in 2007, but
some horizontal stacked bar charts do not. It seems that these latter
charts, if created in 2007, will display in earlier versions.
I've managed to have a look at 'Professional Excel Development', which
suggests a front-lodaer VB6 EXE to start Excel without triggering the
macro security checks. It's probably beyond me , but I'll delve into
it a bit further.

That front-loader was beyond me when I first tried it, but I've figured it
out and made a few little enhancements. It works in 2007 (at least in Win
XP, tho some users with Vista are having problems which may or may not be
related).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______