Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting view area to user
Hello, I would like to restrict the user of an app to view just som designated area,Let's say from A1:Z200. It's that possible with VBA? Thank you all, Best regards jose lui -- jose lui ----------------------------------------------------------------------- jose luis's Profile: http://www.excelforum.com/member.php...fo&userid=1331 View this thread: http://www.excelforum.com/showthread.php?threadid=26975 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting view area to user
You could set the row height and column width to 0 for ranges outside your
desired view. -- Rob van Gelder - http://www.vangelder.co.nz/excel "jose luis" wrote in message ... Hello, I would like to restrict the user of an app to view just some designated area,Let's say from A1:Z200. It's that possible with VBA? Thank you all, Best regards jose luis -- jose luis ------------------------------------------------------------------------ jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312 View this thread: http://www.excelforum.com/showthread...hreadid=269754 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting view area to user
jose
You can hide the rows and columns you don't want to see. Select them and FormatHide. Then protect the worksheet. Alternative.........You may want to try setting the Scroll Area. This setting will not remain after closing the file. Place a code line in the Workbook open event to set it each time when you open the workbook. Right-click on the Excel Logo left of your "File" on menu. Select "View Code" and paste the following in there. Save the workbook and close/re-open to see the scrollarea fixed to the range A1:H40 Private Sub Workbook_Open() Sheets("Sheet1").ScrollArea = "A1:Z200" End Sub Adjust to your sheetname and range. Note: if users diable macros, the second method will be rendered useless. Gord Dibben Excel MVP On Fri, 15 Oct 2004 17:49:19 -0500, jose luis wrote: Hello, I would like to restrict the user of an app to view just some designated area,Let's say from A1:Z200. It's that possible with VBA? Thank you all, Best regards jose luis |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting view area to user
I would like to restrict the user of an app to view just ...
Just a thought. Even if you also included a restriction to the ScroolArea with... ActiveSheet.ScrollArea = "A1:Z200" One could type a cell address (outside this range) in the "Name Box" to view that cell's contents in the formula bar. You may want to consider Protecting the sheet as well. -- Dana DeLouis Win XP & Office 2003 "jose luis" wrote in message ... Hello, I would like to restrict the user of an app to view just some designated area,Let's say from A1:Z200. It's that possible with VBA? Thank you all, Best regards jose luis -- jose luis ------------------------------------------------------------------------ jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312 View this thread: http://www.excelforum.com/showthread...hreadid=269754 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting view area to user
I've tried to dynamically set = Worksheets(1).ScrollArea = "A11:EU65536", but
was unable. In case you don't know the limits of your window you want to show to the user. I went this way: ThirdString = ":" FourthString = """" NewString = FourthString & Assumptions.Range("Msg1").Text & ThirdString & _ Assumptions.Range("Msg2").Text & FourthString Assumptions.Range("Msg2").Offset(2, 0) = NewString Worksheets(1).ScrollArea = FourthString & Assumptions.Range("Msg1").Text & ThirdString & _ Assumptions.Range("Msg2").Text & FourthString I always get an "Application defined or object-defined error" prompt. The above "Worksheets" area definition should suffice if you know beforehand the limits of the area you want to show. "jose luis" wrote: Hello, I would like to restrict the user of an app to view just some designated area,Let's say from A1:Z200. It's that possible with VBA? Thank you all, Best regards jose luis -- jose luis ------------------------------------------------------------------------ jose luis's Profile: http://www.excelforum.com/member.php...o&userid=13312 View this thread: http://www.excelforum.com/showthread...hreadid=269754 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table limiting user selection | Excel Discussion (Misc queries) | |||
View set to 'best fit' for User | Excel Discussion (Misc queries) | |||
Chnge view order, Area chrt? | Charts and Charting in Excel | |||
specific user view | Excel Discussion (Misc queries) | |||
Format worksheet to view only the print area cells in Excel | Excel Discussion (Misc queries) |