macro coding to show item from specified cell.

Originally Posted by teylyn

This has nothing to do with password protection.

Worksheet protection prevents unintentional changes of cells, which seems to be what you want to achieve.

Post a workbook and explain in context what you want to do.

If you use macros to manipulate the sheet, you can use code to unprotect the sheet in the macro as required.

Friend,

Here by i have attached my excel. please have a look.

I need the column K to reflect the date in column Y. As i already said this can be simply done by the formula

=Y3

. But if you see my excel i have written all the formulas in VBA code and my main aim is to create the excel without any formulas in the sheet. I have done almost 99% but i couldnt write macros only for this case.

If you could help me on this it will be really great.

VBA Password: BULK123