Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default HOW TO LOCK THE OPENING OF AN EXCEL SHEET?

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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW TO LOCK THE OPENING OF A SHEET(TAB)? Excel Locker Excel Discussion (Misc queries) 3 September 20th 07 07:11 PM
Delete Custom Formating when Excel sheet is Lock. Suresh Kemnaik Excel Discussion (Misc queries) 0 August 14th 07 11:04 AM
I FORGOT MY PASSWORD AND THE EXCEL SHEET IS LOCK HOW CAN I UNLOCK Asaf Excel Discussion (Misc queries) 1 October 4th 06 02:50 AM
How to: lock & E-mail an excel sheet? Fritz Excel Discussion (Misc queries) 2 August 24th 06 07:16 PM
Lock up when opening files in Excel Mike in the UK Excel Discussion (Misc queries) 1 April 15th 06 01:35 PM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"