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

  • Thread starter Thread starter nilangini
  • Start date Start date
N

nilangini

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.
 
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.
 
Back
Top