View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nilangini nilangini is offline
external usenet poster
 
Posts: 1
Default 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.