Is there any way to access the formula bar through VBA code?
 

Greetings,
When I protect my excel sheet, I am no longer able to see the contents
of the cells in the formula bar even for the cells which are not
locked.
Is there any way to achieve this in Excel 2000?
Can I write a code in some event where I can copy the text from the
currently selected cell to the formula bar?
Thanks.

Is there any way to access the formula bar through VBA code?
 

This isn't usual behavior.

Unlocked cells on protected sheets should still show up in the formula bar.

I'd double check that lockedness and hiddeness of that cell.

nilangini wrote:

Greetings,
When I protect my excel sheet, I am no longer able to see the contents
of the cells in the formula bar even for the cells which are not
locked.
Is there any way to achieve this in Excel 2000?
Can I write a code in some event where I can copy the text from the
currently selected cell to the formula bar?
Thanks.

--

Dave Peterson