HOW TO LOCK THE OPENING OF AN EXCEL SHEET?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I would like to send an excel file to 2 person.
I want the first one to be able to open the 4 sheets and the second person
to be able to open ONLY the first 2 sheets (therefore I don't want him to see
the 2 'banned' sheets).
Using a password is ok with me, but just can't find the way to do that (I
can hide, I can lock...but I cannot LOCK the opening itself of the sheet)

Thank you very much in advance to anyone able to help with that.

Best regards
 
Hey!

Try to use "Protect Sheet", in the Functions menu (No 6 from the left).

I don't have an English version, so unfortunately I can't tell you the exact
names. Don't forget to lock the wished sheets.


Kind Regards
Aron

"Excel Locker" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW TO LOCK THE OPENING OF A SHEET(TAB)? 3
How do I lock ONLY the formatting on an excel sheet? 2
Allowing editing locked cells in a protected sheet in excel 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Excel spreadsheets opening at top instead of bottom. 4
Change cell color in protected sheet 1
Combining Excel Files 0
sheet protection in excel 2003 version 8

Back
Top