free Cheque Print Bandara.xls
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Cheque printing without special software or Printer
3
4
You can create a simple Cheque printer for your small business using Excel.
5
if you write cheques manually this method will very useful for you .
6
not need to buy separate cheque printer. you can use your normal laser printer and your computer to do this.
7
8
First you have to enable macros to your excel.
9
I have create here very simple excel work book.
10
you have to do only below few things to set your cheque to print.
11
12
1) save attached excel file to your computer your favorites folder.
13
14
2)open office excel program and enable macros.
15
A) if you already have enable macros. The following massage will appear.
16
17
When you open a file that has macros, the yellow Message Bar appears with a shield icon and the Enable Content button.
18
19
20
On the Message Bar, click Enable Content.
21
The file opens and is a trusted document.
22
23
24
25
B)if you not enable macros: do like this.
26
Macro settings are located in the Trust Center. Hmight have changed the default settings to prevent anyone from changing settings.
27
28
1. Click the File tab.
29
2. Click Options.
30
3. Click Trust Center, and then click Trust Center Settings.
31
4. In the Trust Center, click Macro Settings.
32
5. Make the selections that you want.
33
6. Click OK.
34
35
The following image is the Macro Settings area of the Trust Center.
36
37
38
39
40
41
42
43
44
45
46
47
48
so enable all macros.
49
50
3) now open the save excel file.
51
you can see three work sheets .
52
first one for your cheqe detail.
53
second cheque printer
54
Third one your customer/supplier list.
55
56
57
58
59
60
4) now you have to scan one of your cheque leaf from your cheque book as a picture and insert it to second sheet.
61
62
according to your bank cheqe leaf will be difference.
63
drag the ceque leaf to the first cheq merging and
64
drag and drop the cheqe details to the correct place of cheqe picture.
65
after you drag all cheqe details to correct place. Remove cheqe picture.
66
now you can copy & paste first cheqe margins to down for 15 cheqes and only change the formula of amount & word for each.
67
68
5)now you are ready. go to the third sheet and update your customer/suppler name how you want to appear it in your cheqe.
69
70
6)go to first page. Select suppliers and enter amounts. It will update second cheque print sheet.
71
you can enter the ceque no and keep it for your recoerds.
72
7)print preview and see all are correct. First print test page and see all margins are ok. If not drag to correct place and save.
73
74
JMN Bandara
75
bandara.jmn@gmail.com
76
http://fiverr.com/bandarajmn
77
https://sites.google.com/site/ibayasia/
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu