Print your office or personal Checks simply using MS Excel for your business.
This simple worksheet will very useful if you write lot of checks manually to your suppliers daily.
This simple excel work book, You can download it free. and play....
1) save attached excel file in your favorites folder.
2) open office excel program and enable macros.
B) If you not enable macros in your excel program file not work properly:
How to do it : Macro settings are located in the Trust Center.
1. Click the File tab.
6. Click OK.
There are three work sheets .
Drag the check leaf to the first check margin ...,
See the green color drop it can move to any place.
This simple worksheet will very useful if you write lot of checks manually to your suppliers daily.
With this method you not need to buy special printer or software.
You can use normal printer and your computer to print 100s of checks soon.
You can use normal printer and your computer to print 100s of checks soon.
First you have to enable macros to your excel work sheet.
This simple excel work book, You can download it free. and play....
You have to do only few things to set your checks ready to print.
2) open office excel program and enable macros.
When you open the file , a yellow Message Bar appears in upper under mane bar.
A) Click Enable Content button.
A) Click Enable Content button.
The file will open as a trusted document.
B) If you not enable macros in your excel program file not work properly:
How to do it : Macro settings are located in the Trust Center.
1. Click the File tab.
2. Click Options.
3. Click Trust Center, and then click Trust Center Settings.
4. In the Trust Center, click Macro Settings.
5. Make the selections that you want.
3) now open the save excel file.
There are three work sheets .
- first one for your cheque detail. (chdetails)
- second cheque printer (cheqprint)
- Third one your customers/suppliers list. (payee list)
4) now scan an one of your check leaf from your check book and insert it to 2nd sheet to format the age.
According to size of your bank check, format of leaf will be difference.
Drag the check leaf to the first check margin ...,
and drag and drop the details to the correct place of check picture.
See the green color drop it can move to any place.
After you drag all cheque details to correct place. Remove check scan copy.
Now you can copy & paste first cheque margin to down for 10 checks.
Now enter your payee list and save. When you need to create checks just go to checks details sheet.
- select the payee name form drop down list.
- enter the amount
- 10 checks you can print in one time easily.
** Now new Database version also available free....
