Strange behavior from some simple VBA code

**calibra** · 04-25-2012, 02:38 PM

Hi

I have a simple 2 line VBA code which unhides a sheet then selects it.

Problem is it `appears` to open it twice !!!

The sheet is displayed, then all the shapes etc. flicker off than back on again.......strange thing is it doesn`t seem to happen the very first time the code is run, but does thereafter.

Please Login or Register  to view this content.

Any ideas ???

Thanks

Calibra

**Paul** · 04-25-2012, 03:03 PM

Hi Calibra,

Have you tried adding "Application.ScreenUpdating" before and after the sheet un-hiding process?

Please Login or Register  to view this content.

With only a few objects the re-draw isn't noticeable, but with many it definitely is (without the screenupdating turned off).

**MaczaQ** · 04-25-2012, 03:06 PM

could you attach dummy workbook ?

consider to use:

Please Login or Register  to view this content.

-1 for xlSheetVisible
0 for xlSheetHidden
2 for xlSheetVeryHidden

**calibra** · 04-25-2012, 04:47 PM

Originally Posted by Paul

Hi Calibra,

Have you tried adding "Application.ScreenUpdating" before and after the sheet un-hiding process?

Please Login or Register  to view this content.

With only a few objects the re-draw isn't noticeable, but with many it definitely is (without the screenupdating turned off).

Brilliant !!! Worked perfectly.......Thanks
I actually really enjoy VBA in excel, is there a good resource with sample code.......hopefully free !!

Thanks again

P.S. Could you look at my post Stopping movement of shapes excel 2010....maybe you could help