ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pseudo text box in Excel 2003 Built-In template (https://www.excelbanter.com/excel-discussion-misc-queries/221006-pseudo-text-box-excel-2003-built-template.html)

Polaris

Pseudo text box in Excel 2003 Built-In template
 
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?

Ron Rosenfeld

Pseudo text box in Excel 2003 Built-In template
 
On Sat, 14 Feb 2009 05:30:03 -0800, Polaris
wrote:

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

Polaris

Pseudo text box in Excel 2003 Built-In template
 
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.

"Ron Rosenfeld" wrote:

On Sat, 14 Feb 2009 05:30:03 -0800, Polaris
wrote:

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


Ron Rosenfeld

Pseudo text box in Excel 2003 Built-In template
 
On Sat, 14 Feb 2009 06:01:01 -0800, Polaris
wrote:

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


All times are GMT +1. The time now is 02:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com