I'm generating a menu using MenuMaker, where I list on a sheet within a file
the applicable menu info, as follows, then put code in the file to generate
the menu. Problem is that in some of my captions I want to use the ampersand
(see below), but when I use the & sign, Excel thinks I want to underline the
character after it. How do I enter the caption so that it comes out
correctly as just B&P?

Level Caption Position/Macro Divider FaceID
1 B&P
2 Input Tab
3 Copy CP

How about: B&&P

Same kind of thing when you want an ampersand in a header or footer.



Paige wrote:

I'm generating a menu using MenuMaker, where I list on a sheet within a file
the applicable menu info, as follows, then put code in the file to generate
the menu. Problem is that in some of my captions I want to use the ampersand
(see below), but when I use the & sign, Excel thinks I want to underline the
character after it. How do I enter the caption so that it comes out
correctly as just B&P?

Level Caption Position/Macro Divider FaceID
1 B&P
2 Input Tab
3 Copy CP

--

Dave Peterson

B&&P wil give you B&P without the underlined character.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 14:35:02 -0800, Paige
wrote:

I'm generating a menu using MenuMaker, where I list on a sheet within a file
the applicable menu info, as follows, then put code in the file to generate
the menu. Problem is that in some of my captions I want to use the ampersand
(see below), but when I use the & sign, Excel thinks I want to underline the
character after it. How do I enter the caption so that it comes out
correctly as just B&P?

Level Caption Position/Macro Divider FaceID
1 B&P
2 Input Tab
3 Copy CP

Thanks, guys!!!!

"Gord Dibben" wrote:

B&&P wil give you B&P without the underlined character.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 14:35:02 -0800, Paige
wrote:

I'm generating a menu using MenuMaker, where I list on a sheet within a file
the applicable menu info, as follows, then put code in the file to generate
the menu. Problem is that in some of my captions I want to use the ampersand
(see below), but when I use the & sign, Excel thinks I want to underline the
character after it. How do I enter the caption so that it comes out
correctly as just B&P?

Level Caption Position/Macro Divider FaceID
1 B&P
2 Input Tab
3 Copy CP