LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Outlining works in XP not in 2000

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Works Spreadsheet 2000 v5.0 VLOOKUP John L. Excel Worksheet Functions 1 August 7th 05 08:05 PM
Save As... MS Works 2000 spreadsheet Thomas Excel Discussion (Misc queries) 2 May 7th 05 06:56 PM
Macro works in 2000 not XP for Progress Bar Far Excel Programming 0 May 19th 04 09:42 PM
Macro works fine in xl2002 but does not in xl 2000 Nolin[_2_] Excel Programming 1 February 25th 04 05:58 PM
VBA Code works in 2000 not 97 Michael Beckinsale Excel Programming 1 January 20th 04 05:38 PM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"