Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2005

Tip: Looking for answers? Try searching our database.

password protected

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
guideme - 11 Jun 2005 01:12 GMT
can I secure a sheet when it's a vlookup design?
I have 2 sheets... sheet 1 is for my vlookup formula, sheet 2 is where
all my data reside and it's hidden.

now. sheet 1 is interactive where-in users enter in an area code, hit
enter then it populates the data from the sheet 2.

I tried password protection but if I did that, it won't let users enter
in an area code hence extract info. from sheet2.

what's my alternative?
Bill Kuunders - 11 Jun 2005 07:00 GMT
Protect the sheets but unlock the cells the user needs access to.

to unlock, go to:
format<>cells<>protection

Signature

Greetings from New Zealand
Bill K

> can I secure a sheet when it's a vlookup design?
> I have 2 sheets... sheet 1 is for my vlookup formula, sheet 2 is where
[quoted text clipped - 7 lines]
>
> what's my alternative?
guideme - 11 Jun 2005 20:01 GMT
Hi Bill,
Thanks that worked, but I have another problem... I want the cursor to
stay on the cell where they enter the area code on that specific sheet
only.
(not the whole excel program).
Bec. when I went to Tools/options/edit/uncheck the "Move selection
after Enter".
Every time I work on another worksheet which is unrelated to the said
sheet. The cursor does not move down when I hit enter, of course it
works when I hit arrow down or up.
any insights?
Bill Kuunders - 11 Jun 2005 20:46 GMT
This requires a small macro instruction into the worksheet code.

To get there
right click onto the sheet tab and select <>view code<>

select "worksheet" in the dropdown list which shows "(General)"
select on the right window "activate" and paste the code

Application.MoveAfterReturn = False

between the Private sub()........and
End sub() lines.

select "deativate" and paste the code

Application.MoveAfterReturn = True

between the Private sub() and
End sub() lines.

Greetings from New Zealand
Bill K

> Hi Bill,
> Thanks that worked, but I have another problem... I want the cursor to
[quoted text clipped - 7 lines]
> works when I hit arrow down or up.
> any insights?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.