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