Microsoft Excel Sheet

R

raju7763

Dear all

I M using excel since long but now I wanted to share my excel shee
with other user also. Now I wanted to lock some cells in which I mak
some formula's . So pl let me know how I will lock cell ? and if I wan
to change in lock cell how it will work ?

Thahx

Pramod Kawthekar
Indore , Indi
 
P

Peo Sjoblom

Select the whole sheet, d format>cells>protection and make sure that locked
is not selected, then select all the cells you want to protect
and repeat but make sure locked is checked. Finally password protect the
sheet.
You should however know that cracking the password with a macro is a piece
of cake for someone who knows how to use a search engine



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 
A

Avinash Shukla

ITS VERY SIMPLE - FIRST GO TO CELLS-CLICK ON HIDE THEN OUT OF IT & THEN
PROTECT THE SHEET WITH PASSWORD YOUR SHEET IS PROTECTED .FORMULAS HAS BEEN
HIDED
BUT THERE IS ONE MAIN PROBLEM IS THAT U CAN NOT LOCK THE SHEETS.
THANKS
AVINASH -INDIA-PUNE
 
V

vishwa

Dear all

I M using excel since long but now I wanted to share my excel sheet
with other user also. Now I wanted to lock some cells in which I make
some formula's . So pl let me know how I will lock cell ? and if I want
to change in lock cell how it will work ?

Thahx

Pramod Kawthekar
Indore , India

--
raju7763
------------------------------------------------------------------------
raju7763's Profile:http://www.officehelp.in/members/6983/raju7763
View this thread:http://www.officehelp.in/1492845/microsoft-excel-sheet

http://www.officehelp.in
Click to expand...

Pramod
which version of Excel you are using?
vishwanath
 
Top