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: 103
Default Setting visible range

I am interested in doing two separate things, both primarily for aesthetic
reasons. First, and more importantly, I would like to be able to set the
visible area (e.g. A1:X150). Either, the user could not travel out of the
area or it would simply not be visible. Hiding the unwanted range is
possible seems a little over the top, but this would work fine. Is there
something better?

Second, is it possible to make it so that locked cells can not be selected
or even hightlighted.

Any help is appreciated. Thanks.
 
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
Chart not visible -suspect scale setting? Big Mac Charts and Charting in Excel 0 March 12th 07 01:40 PM
setting visible (ie displayed) part of the worksheet gvm Excel Programming 2 November 18th 05 01:01 AM
setting range().hidden=True causes range error 1004 STEVE BELL Excel Programming 6 September 2nd 05 02:16 AM
Help finding error setting range to Visible Cells Ed Excel Programming 3 January 26th 05 06:11 PM
error with setting "Items.Visible = True" Stan R Excel Programming 1 August 20th 03 09:51 AM


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