View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default 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