LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default formatting the view of a worksheet


I have a button on a worksheet that selcts a cell on
another sheet.

I want to display the cell so that it is in the upper left
corner of the window, but I can't find any method to do
this. Any help appreciated.

Code so far (works fine):

Private Sub SectionAHelpButton_click()
Sheets("Instructions").Select
Sheets("Instructions").Range("SectionAHelp").Selec t
End Sub

but SectionAHelp might appear at the bottom of the page,
and I want it to appear at the top left.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
under the view tab where is formatting palette toolbox? collegegirl Excel Discussion (Misc queries) 1 September 18th 09 02:05 PM
view cell formatting Ferds Excel Discussion (Misc queries) 1 December 6th 07 03:51 AM
Need to Save File to View Conditional Formatting Changes whynot0611 Excel Discussion (Misc queries) 0 October 26th 07 05:01 PM
How do I view the formatting of a cell Debi Excel Discussion (Misc queries) 4 October 31st 06 07:29 PM
How to view a custom view when the worksheet is protected? JulesJam Excel Worksheet Functions 0 March 6th 06 02:15 PM


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"