View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geo Siggy[_3_] Geo Siggy[_3_] is offline
external usenet poster
 
Posts: 1
Default VBA - Only Selected area visible

Excel VBA programming : How to make only a selected sheet area visible,
e.g. the row 12 until the end shall be invisible and the column X until
the end shall be invisible. The problem may be that different Excel
versions have different max rows and columns. And how to adjust the
scrollbars to that selected area. What if the selected area is smaller
than the usable width of the Excel spreadsheet. The function of sizing
the width and height will not work ?


---
Message posted from http://www.ExcelForum.com/