LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default showlevels is very slow

I don't think you can.

But you could do the whole thing in code. Don't click on the outlining
symbols. Use your macro (macros???) instead.

kurt wrote:

Hi all

Thank you Dave for your answer, Yes I anm familiar with this method.

But how do you do it from a macro, I need a trigger so when i pres the
square top left then
stops the recalc
does the showlevel function
start the recalc

thanks in advence

regards
Kurt


--

Dave Peterson
 
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
Slow Excel Navigation with Up / Down Arrow and slow scrolling deddog Excel Discussion (Misc queries) 0 August 14th 07 09:56 PM
Outline.ShowLevels rowlevels:=1 is slow Jan Vente Excel Programming 2 May 19th 05 12:45 PM
Outline.ShowLevels Kevin McCartney Excel Programming 1 April 21st 05 12:09 PM
Outline.ShowLevels Kevin McCartney Excel Programming 2 April 20th 05 05:13 PM
Outline.ShowLevels KaiRich Excel Programming 2 June 25th 04 01:48 AM


All times are GMT +1. The time now is 11:18 AM.

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

About Us

"It's about Microsoft Excel"