converting from formula to text or paste special

[exceluser9]

Hi There,

I have put in a formula in excel until column z and for 70 row from sheet 2

Is there a way to convert formula into text so that no one see my formula?

Vba is also fine

 

[pgc01]

Remark:

If you want to hide the formula you could simply protect the worksheet.

 

[exceluser9]

Tried but still formulas can be seen in formula bar

 

[Rick Rothstein]

Tried but still formulas can be seen in formula bar

Did you Lock the cells with the formulas in them and when you protected the sheet, did you make sure the first check box (labeled "Select locked cells") was unchecked?

 

[pgc01]

Tried but still formulas can be seen in formula bar

Before you protect the sheet, select the cells where you don't want the formula to be seen and in the cell properties tick the Hidden checkbox.

Then you protect the sheet and those formulas are not seen in the formula bar.

 

[exceluser9]

Not sure what I'm doing, I locked the cells from editing by other user
My request is I don't want any users to see my formula in formula bar and even if they tick formula options it should not be visible

 

[pgc01]

Did you see my last post?

 

[exceluser9]

Yes sir its working now

 

[pgc01]

I'm glad it helped. Cheers!

 

[exceluser9]

Cool