View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Outlining works in XP not in 2000

If it doesn't work, there isn't a magic statement that will make it work.
You should do your development in the lowest version of Excel that will use
the code.

In any event, outlining and grouping were supported in xl2000 as well.
Perhaps there are some additional arguments you have provided in xl2003 that
are not recognized in xl2000. It is hard to say since you show no code and
don't say whether you get an error or the macro runs, but nothing happens.

--
Regards,
Tom Ogilvy

"Metallo" wrote in message
...
I finished writing the coding and macro into my WB.
All is working fine in XP (Office 2003)

Since I know that some of the users work in W2K + Office 2000, I made a
test, and the result is that all is working except the outlining after I

run
the Macro (I recoded it to change some formatting when it is needed)

I have a WokbookOpen event that allows the outlining and in a separate
module the above mentioned Macro to format some of the sheets.
I tried the outlining before running the Macro (in 2000) and works ok,

then
I run the Macro to format the sheets and the Outlining is no longer

working.
This happens only in 2000.

What shall I put at the beginning of the code of the formatting macro

to
get it to work?

Thanks
Alex