View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT[_2_] JT[_2_] is offline
external usenet poster
 
Posts: 96
Default Do not display information in cells

I have a macro where I capture a code and vendor name. I
can change the font to "white", so the user can't see it
displayed in the cell but you can still see what is typed
in the formula bar.

Is there a way to hide what is displayed in the formula
bar without removing the formula?

Thanks for the help......