Microsoft Excel Sheet
 

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

Microsoft Excel Sheet
 

Select the whole sheet, d formatcellsprotection 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)

"raju7763" wrote in message
...

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

Microsoft Excel Sheet
 

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
"raju7763" wrote in message
...

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

Microsoft Excel Sheet
 

On Jun 27, 6:32 am, raju7763 wrote:
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

Pramod
which version of Excel you are using?
vishwanath