View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Display set range

assuming you want to restrict what the user can look at -
You might be able to do it with the scrollarea property of the sheet. Note
that this would need to be set each time the workbook is opened.

Another approach might be to hide the rows and columns you don't want
viewed.

--
Regards,
Tom Ogilvy

"infojmac " wrote in message
...
Hi,

This is probably very simple, but i don't know how to do it and its
driving me crazy.

I just want to show a set range on a sheet. So the default is that the
user views column 'BU' and onwards.

Just selecting the range doesn't appear to work.

Cheers.


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