Re: $$Excel-Macros$$ How to protect only few cells

2014-12-06 Thread Prafull Jadhav
Dear Ashish, Great! You have given explanation Step by Step. Regards, Prafull Jadhav 9920553518 On 5 December 2014 at 17:13, Ashish Kumar kumar.ashish...@gmail.com wrote: Welcome Putta. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) !

Re: $$Excel-Macros$$ How to protect only few cells

2014-12-05 Thread Ashish Kumar
Hi Putta, Steps for Lock cells : Step 1: Select all cells in current worksheet with pressing the Ctrl key and A key together. Step 2: Right click, and select the Format Cell item from the context menu. Step 3: In the Format Cells dialog box, uncheck the Locked option under Protection tab, and

Re: $$Excel-Macros$$ How to protect only few cells

2014-12-05 Thread Putta Madaiah
Thank you Ashish..this is working fine On Dec 5, 2014 1:52 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Putta, Steps for Lock cells : Step 1: Select all cells in current worksheet with pressing the Ctrl key and A key together. Step 2: Right click, and select the Format Cell item

Re: $$Excel-Macros$$ How to protect only few cells

2014-12-05 Thread Ashish Kumar
Welcome Putta. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ How to protect only few cells

2014-12-04 Thread Putta Madaiah
Hi Friends, How to protect only few cells with a password where users should not be able to update anything in a shared excel file. With regards, Putta -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum