View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aron Aron is offline
external usenet poster
 
Posts: 23
Default HOW TO LOCK THE OPENING OF AN EXCEL SHEET?

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:

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