Pseudo text box in Excel 2003 Built-In template

P

Polaris

The Sales Invoice template (Built-In) in Excel 2003 displays a ‘pop-up’
comment box when you click in any one of the Tax Rate(s) cells. This is not a
standard comment, nor does it appear to be a standard text box. The ‘pop-up’
can be repositioned but it cannot be deleted. When any other cell is
selected, it disappears. Can anyone explain how this created?
 
R

Ron Rosenfeld

The Sales Invoice template (Built-In) in Excel 2003 displays a ‘pop-up’
comment box when you click in any one of the Tax Rate(s) cells. This is not a
standard comment, nor does it appear to be a standard text box. The ‘pop-up’
can be repositioned but it cannot be deleted. When any other cell is
selected, it disappears. Can anyone explain how this created?

I don't have that template, but could the comment be from a Data Validation
setting?
--ron
 
P

Polaris

Ron,

Thanks! That was it! I had to unprotect the worksheet to access Data
Validation and there it was. I never gave Validation a thought.
Again, thank you.
 
R

Ron Rosenfeld

Ron,

Thanks! That was it! I had to unprotect the worksheet to access Data
Validation and there it was. I never gave Validation a thought.
Again, thank you.

You're welcome. Glad to help. Thanks for the feedback.
--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top