Search : in
By :

Make Excel particular sheet protection on net

Last answer on Aug 27, 2009 2:46:44 pm BST Deep, on Aug 25, 2009 7:39:23 am BST 
 Report this message to moderators

Hello,

I have Excel sheet, with containing around 10 sheets, tat sheer was shared in net work with 5 diffrrent persons (systems). each person is responsible for add data's for particular 2 sheet. tat person should not edit or access remaining sheet. Make more clear Eg : I am deep working in Sheet 1 and 2 , I should not edit the data's or formulas in remaining sheets (3,4,....10). same way another person ganesh is working on sheet no 3 and 4, he should have access editing authorization for remaining sheet (i.e sheet 1,2,5,6...10). Like.. But keep it mind this Excel work book is shared common net work

Please Help Me with my problem...


Thanks in advance


Deep

Configuration: Windows XP
Firefox 3.5.2

Best answers for « Make Excel particular sheet protection on net » in :
How to compare 2 excel sheet and combine uniq data? ShowHow to compare 2 excel sheet and combine uniq data? Issue Solution Note Issue I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All i want is to combine both with no redundant records. (A+B...
Start/stop a service using command line ShowStart/stop a service using command line The netsh tool (netsh.exe) can automate the startup or shutdown of a service through the following command line: To start a service: Net start name_of_service To stop a service:...
How to insert picture background on Microsoft! ShowHow to insert picture background on Microsoft! To make a work sheet more appealing, you can add picture to your background. Below is a tip for doing so. Open your Microsoft and select Format> Backgrounds > Printed Watermarks in the menu...
Download Source Code Spell Checker ShowSource Code Spell Checker is a program that offers to check your lines of code, highlight the errors and to report errors detected. You save valuable time by limiting the reading tedious programming codes. Advantage Via the context menu, you can...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...

1

 Excelguru, on Aug 27, 2009 2:46:44 pm BST
  • +1

Password protect the individual sheets with different passwords but all sheets for a particula r user should be the same. and inform the password to you and that particular person A wise man once said, 'I complained that I had no shoes unti­l I met a man who had no feet.'
I am interested in financial Modelling and custom excel deve­lopment with excel macros.

Reply to Excelguru