Thanks Biff, no, no custom toolbars. They do move the cursor (as recorded)
and go to range names, copy, paste and so on. There's some filtering based on
cell contents, posting of results from 1 worksheet to another, print ranges -
that kind of stuff.
I'm not into
VB except for some very basic editing of macros. So when I say
"complex" I'm not talking on a programming level - more of number of actions
and length of procedures which do run into several pages when printed off.
I think I'll install the trial package. 60 days does seem a fair deal. I
think you can generally opt to keep existing versions so I guess its safe to
do.
"T. Valko" wrote:
Do any of your macros interact with the Excel user interface?
Meaning: create custom toolbars? Add custom menus or custom menu items? And
such...
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
Have you seen or used Excel 2007?
It's quite different in appearnace from any previous versions!
Do any of your macros interact with the Excel user interface? If so, that
could be a big problem in Excel 2007. The developers of Excel 2007 didn't
want anyone to mess with the user interface so they made it very difficult
to do, if not almost impossible in some cases.
The best thing you could do is to download a trial version of Excel 2007
and take it for a test drive! Excel 2010 will be coming out soon (no, I
don't have any inside info!) so you might want to consider waiting for the
newest version.
--
Biff
Microsoft Excel MVP
"Kevryl" wrote in message
...
I just upgraded kicking and screaming to Windows 7 (love it) and am
considering an upgrade to Office 2007. I use Excel extensively and my 2
main
files are around 20meg each with a large number of quite complex macros.
Any advisory comments would be appreciated, and I'm particularly
wondering
about forward compatibility and whether my Excel 2000 macros are likely
to
fall over under 2007.
(Also, I'm wondering if the facility has yet been built in to cells to
instruct the cursor on entering to then move to a designated cell?)
.