Worksheet Moves Left when Opening

[Fred Block]

Hi All,

I've got a bunch of controls on an Excel template and moved them out of
plain view (off to the right; sitting over column "P"). When I open the
template template, the sheet moves to the left to expose these controls.
When I initially saved the template the top-left cell was "A1" and now it
opens and the top-left cell is "E1".

Any ideas? Thanks in advance!

- Fred

 

[Michael Bauer [MVP - Outlook]]

Am Wed, 9 Aug 2006 15:04:19 -0400 schrieb Fred Block:

Calling the Range.Show method should do it.

 

[Fred Block]

Hi Michael,

Calling the Range.Show method should do it.

Sure did! Thanks a mint!

- Fred