sheets are "Visible" but I have to scroll to see all of them

**GunNam** · 01-26-2011, 07:32 PM

I have 2 Macros.
#1 macro shows 5 sheets starting with worksheet.Name starting with "B1"
#2 macro shows 5 sheets starting with worksheet.Name starting with "B5"

When I run #1, all sheets are visible and all the tabs are visible at the bottom of the page.
When I run #2, only 2 sheets are visible, and I have to scroll left to make all the tabs visible.

Is there a way to force all the tabs to show? There is definitely room there to display all of them.

Thanks in advance.

**MarvinP** · 01-26-2011, 08:44 PM

Hi GunNam

There is a .Move property that allows you to arrange your worksheets, if that would help. They look like

Please Login or Register  to view this content.

Read http://msdn.microsoft.com/en-us/libr...ffice.11).aspx for more details.

**GunNam** · 01-26-2011, 09:12 PM

Thanks MarvinP.

I actually ended up just activating the first sheet (of the 3 that weren't being displayed) at the end of Macro #2 and now it displays everything without having to scroll left horizontally.

I think we were thinking the same thing, but executed it differently. Thanks!