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: 2
Default Display set area

I have created a user interface on an Excel sheet. It
occupies Range A1:J21

Is it possible to show this area only? The rest of the
sheet is empty so I only want to display this range.
Hopefully, the function will not allow a user to scroll
anywhere. Is this a trim function? Could it be a lock
function?
I am teaching myself VB so a simple explanation would be
v. useful.

Many thanks,

James
 
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
Area display help mustbezim Excel Worksheet Functions 1 March 4th 10 08:41 PM
Client area doesn't display or repaint the extended area from resi ๊ฐ€์„์‹œ๋ƒ‡๊ฐ€ Excel Discussion (Misc queries) 1 October 7th 09 01:33 PM
if any cell value changes, then display in some other area that va Deepti Excel Worksheet Functions 1 July 17th 08 07:03 PM
How can I display my table in chart area? Abeka Charts and Charting in Excel 1 April 27th 07 12:15 PM
how to display the referral area of a name Holly Excel Discussion (Misc queries) 1 February 21st 07 11:38 PM


All times are GMT +1. The time now is 03:00 AM.

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"