ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   invoice template? (https://www.excelbanter.com/excel-programming/364415-invoice-template.html)

Kranek

invoice template?
 
I am using the "invoice" template to create a custome invoice. I need to
change the function of the cell which asks for the state abreviation.
Whenever I select the cell a note pops up explaining that you are to enter
the abreviation for the state. This isn't a comment. I can't figure out
what it is called or how to get rid of it.


Paul B

invoice template?
 
Kranek, select the cell and try data, validation, input message, and see if
there is anything there
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Kranek" wrote in message
...
I am using the "invoice" template to create a custome invoice. I need to
change the function of the cell which asks for the state abreviation.
Whenever I select the cell a note pops up explaining that you are to enter
the abreviation for the state. This isn't a comment. I can't figure out
what it is called or how to get rid of it.




Kranek

invoice template?
 
Tried it. No go. Validation is greyed out. Is there any way of openning
the template as a template?


"Paul B" wrote:

Kranek, select the cell and try data, validation, input message, and see if
there is anything there
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Kranek" wrote in message
...
I am using the "invoice" template to create a custome invoice. I need to
change the function of the cell which asks for the state abreviation.
Whenever I select the cell a note pops up explaining that you are to enter
the abreviation for the state. This isn't a comment. I can't figure out
what it is called or how to get rid of it.





Kranek

invoice template?
 
Tried again after realizing I hadn't removed the protection on the file.
Your suggestion seems to work.
Thanks
Kranek

"Kranek" wrote:

I am using the "invoice" template to create a custome invoice. I need to
change the function of the cell which asks for the state abreviation.
Whenever I select the cell a note pops up explaining that you are to enter
the abreviation for the state. This isn't a comment. I can't figure out
what it is called or how to get rid of it.



All times are GMT +1. The time now is 11:59 PM.

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