| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is teher any way to copy excel sheet on microsoft word....... | Excel Discussion (Misc queries) | |||
| How do I set up a Balence sheet in Microsoft Excel | New Users to Excel | |||
| how to create a dialog sheet in microsoft excel | Excel Discussion (Misc queries) | |||
| MIcrosoft Excel: should allow sheet increase by 1 on fill down | Excel Discussion (Misc queries) | |||
| How to show sheet tabs in Microsoft Excel | Excel Worksheet Functions | |||
Hybrid Mode
