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: 34
Default VB Code to return to top of page

I have a user interface where people can go to a number of hidden tabs by
clicking on command buttons.

What the code does is unhide the tab and makes it active but at the bottom,
is another button which will hide the tab and take them back to the first
screen.

The problem I am having is that the user will need to scroll down the screen
to return to the index so if/when they return, the tab opens half way down
the page.

What I want to know is if there is some code that when it makes a tab
active, that it returns to the top of the screen. I have thought about
setting up bookmarks but I have over 20 tabs and frankly cant be bothered lol.

Cheers in advance for your help!

Mav
 
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
return what page a named range is on Chris Salcedo Excel Programming 1 January 29th 07 01:35 AM
Page# Return off lookup FASTWRX Excel Programming 5 June 12th 06 06:39 PM
Excel 2002 VBA code to return a page number within a worksheet JCIrish Excel Programming 1 February 19th 06 09:23 PM
Return to Main Page oberon.black[_37_] Excel Programming 1 September 11th 05 05:18 PM
Return no of rows per page Neil Waterworth Excel Programming 4 January 23rd 05 04:53 PM


All times are GMT +1. The time now is 05:24 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"