Hide the Formula

Submitted by Tom Urtis.

The Excel formula bar drops down and covers cells when a cell containing more than 50 characters is selected. The following sample prevents this from happening by hiding the formula bar. In Figure 13.14, the formula bar would normally obscure most of this worksheet. Thanks to the following macro, the formula bar is hidden:

Figure 13.14

Normally,the formula bar would obscure most of this worksheet.The macro causes the formula bar to be selectively hidden whenever the cell contains more than 50 characters.

Microsoft Excel - Uilit HirWnrmuliiEl.-v xl

Ü] fie Etil üiftv Insert Filmai lodi [lata Mrcfcw Help Ach:ta:

□ G? H til S a V X £ IK <? 1 • n. -1 « E f. H « u |ug

0 0

Post a comment