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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nilangini - 23 Feb 2006 10:58 GMT

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.

Reply to this Message

Dave Peterson - 23 Feb 2006 15:48 GMT

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.

> Greetings,
> When I protect my excel sheet, I am no longer able to see the contents
[quoted text clipped - 4 lines]
> currently selected cell to the formula bar?
> Thanks.

Signature

Dave Peterson

Reply to this Message