How can you use repaint method in Workbook_Open macro?

[novena]

Hi all,

I'm working on a large multi-tab Excel 2000 spreadsheet that contains several pivot tables. When a user initially opens the spreadsheet, a portion of the active sheet is overlaid with a portion of a pivot table that doesn't get repainted for some reason. Everything works okay, it's just ugly (and confusing for the users.)

The spreadsheet is set to manually recalculate. (Autocalc isn't an option at this point because of its size and complexity.)

I'm trying to set up a Workbook_Open macro to repaint the active sheet upon opening the workbook, but I keep getting "method not supported" errors back when I try to refer to the active sheet using any object identifier I can think of.

Any suggestions?

Thanks,

Jeremy

 

[xlbo]

try setting the view to full screen and back - that usually wakes excel out of its coma

The issue is with memory - I get this a lot with large workbooks - fortunately, most of them are for me only so it isn't a problem

application.displayfullscreen = true
application.displayfullscreen = false


Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[novena]

Thanks for the suggestion, Geoff.

Unfortunately, that didn't seem to do the trick. I'm wondering if maybe I need a different event trigger.

- Jeremy

 

[xlbo]

Repaint only refers to Form objects (including page objects and controls)

Can't think of anything specific that I know would work....can you sort it manually ?? if so, how and we'll try and put that into cod

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question