A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Worksheet Moves Left when Opening



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old August 9th 06, 09:04 PM posted to microsoft.public.outlook.program_vba
Fred Block
external usenet poster
 
Posts: 5
Default Worksheet Moves Left when Opening

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


  #2  
Old August 10th 06, 06:54 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Worksheet Moves Left when Opening

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

Calling the Range.Show method should do it.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


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

  #3  
Old August 14th 06, 08:58 PM posted to microsoft.public.outlook.program_vba
Fred Block
external usenet poster
 
Posts: 5
Default Worksheet Moves Left when Opening

Hi Michael,

Calling the Range.Show method should do it.


Sure did! Thanks a mint!

- Fred


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
i can't get outlook to import info from the worksheet it created oaksie1 Outlook - General Queries 5 July 20th 06 06:13 PM
Help emailing worksheet range via Redemption [email protected] Outlook and VBA 1 July 17th 06 07:36 PM
Hyperlinking from Outlook 2003 to an excel Worksheet fidgitthedigit Outlook - General Queries 2 May 5th 06 05:32 PM
Can't open calendars after mailbox moves. X-Jack Outlook - Calandaring 1 April 14th 06 07:26 PM
Why does calendar moves some appointments one hour ahead dtss Outlook - Calandaring 2 April 11th 06 10:36 PM


All times are GMT +1. The time now is 09:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.