Printable fields in Excel?

  • Thread starter Thread starter ckad79
  • Start date Start date
C

ckad79

I don’t use Excel a lot, but I am familiar with the program.

This is the deal... I’m trying to create an Excel form for this local
restaurant that I’ve been doing some work for. They have customers call
in to order party platters, so there has to be fields for their credit
card number, expiration date, what type of platter they want and how
many people it feeds, etc. The thing is when they print them off, they
want the printable copies to show everything (the customer’s address,
phone number, etc) but they want the credit card number and expiration
date left invisible), so if an associate looses the form, somebody
won’t have all that personal information but it can still be accessed
on their computer.

Is this possible... to create a form with only certain printable
fields???

Thanks.
 
Hi ckad79,

this is definetly possible, but my personal opinion would be to stay away
from excel if you're going to put credit card information. excel wouldn't be
the best for this, I would recommend that you use access instead. it is much
more secure when it comes to this kind of information.

just my 0.02 cents....
_____________________
Thanks,
salah
http://leitek.com
 
salooha said:
Hi ckad79,

this is definetly possible, but my personal opinion would be to stay away
from excel if you're going to put credit card information. excel wouldn't be
the best for this, I would recommend that you use access instead. it is much
more secure when it comes to this kind of information.

just my 0.02 cents....
_____________________
Thanks,
salah
http://leitek.com



:
Click to expand...
Storing credit card info is risky business. It's best if you don't store
it at all and have the customer give their card number each time.

gls858
 
They would need the credit card incase the charge is disputed.

I know sometimes, when orders are placed online... the code will return
on the order form as XXXX-XXXX-XXXX-XXXX or just the last four digits in
there for record keeping.

I'm going to get Access a try but for the time being can somebody
please explain how to make printable and non-printable fields.
 
ckad79 said:
I don’t use Excel a lot, but I am familiar with the program.

This is the deal... I’m trying to create an Excel form for this local
restaurant that I’ve been doing some work for. They have customers call
in to order party platters, so there has to be fields for their credit
card number, expiration date, what type of platter they want and how
many people it feeds, etc. The thing is when they print them off, they
want the printable copies to show everything (the customer’s address,
phone number, etc) but they want the credit card number and expiration
date left invisible), so if an associate looses the form, somebody
won’t have all that personal information but it can still be accessed
on their computer.

Is this possible... to create a form with only certain printable
fields???

Thanks.


--
ckad79
------------------------------------------------------------------------
ckad79's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26315
View this thread: http://www.excelforum.com/showthread.php?threadid=395872
Click to expand...
Not sure if this is the ideal solution for you, but I developed a solution for a similar problem. Depending on the complexity of the "Order Form" this may take some time, so be warned.

Once you have created the form, I copied it onto a second sheet within the same workbook, and created lookups on the second page for all the information I wanted (missing out all confidential info).

Then create two PRINT macro buttons on the first page, one for the ORDER FORM and another for the DELIVERY NOTE. Optionally you can then hide the second (DELIVERY NOTE) page from view, to prevent meddling fingers!

This worked with 62 hidden pages so hopefully it will work for your 2.

Mail back if you want more info.

Dave
 
Last edited:
Back
Top