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: 10
Default display in web page format & paging

In an Excel 2003 spreadsheet, I have my layouts in sheet1, my data is input
for these layouts are inputted from sheet2.
The layouts consist of 28-30 rows (this can be changed to fit on a screen).
I want to display on the screen the 30 rows of sheet1.
A laptop will be connected to a big screen TV so it can be viewed in a large
room.
I want to pause a few seconds, page down and display the next 28 or 30
rows, pause, page down...etc.
When I reach the bottom, I want to go to the top and start the display
again. The display should be in "web page format" or "print preview format".
To stop the process, the user press the ESC key.

This has done before. It displays groups of 4 teams in a round robin format
that
is updated during the event. The previous code was limited to 72 teams - 18
screens. It needs to be expanded. The macros were pass protected and are
unaccessible.

How do I do put the worksheet in webpage format and page down thru it?

Thanks
Joe

 
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
How to display current page number in any cell of that page. Laljeet Excel Discussion (Misc queries) 8 February 2nd 08 01:31 AM
Paging Toppers for the macro driller Excel Worksheet Functions 4 February 8th 07 08:22 PM
Why does paging down skip ten rows? RADEANO Excel Worksheet Functions 2 May 1st 06 12:40 PM
Paging down to last entry Richard Excel Discussion (Misc queries) 4 April 30th 06 12:39 AM
Landscape print with Letter paging MacroMan Excel Programming 0 July 11th 03 09:21 PM


All times are GMT +1. The time now is 10:13 AM.

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

About Us

"It's about Microsoft Excel"