Hey guys this site has been very helpful with my excel project however I have stumbled on this. I have hidden all the toolbars and ribbon except for the formula bar line. The user is putting information into certain cells where some contains too much text to display in the cell's dimensions. So the idea was to show the formula bar to display all the data. However, the name box can drop-down to go to several hidden name groups which are not supposed to be accessible. Any suggestions to how to hide the name box or a work around to show all the data in a cell? Thanks in advance.
Bookmarks