Hi V.Kiran, If you need to use an exact copy of the bank's form, it may be a bit tricky in Excel. Whether to use Excel at all, and what approach to take if you do, depends on the reason you are trying to undertake this.
For example, if you want to use an exact copy of the bank's form, and your reason is just to be able to fill the form out on the computer -- Excel is not ideally designed for this (it would be a good deal of work to make it work nicely in Excel). Adobe Acrobat documents into fillable forms very readily - https://www.adobe.com/products/acrobatpro/create-fillable-pdf- forms.html - and even collect the data. If it will be integrated with a spreadsheet, perhaps with the deposit slips automatically being filled in by formulas or macros, then perhaps implementing it in Excel is worth the trouble. A few approaches that come to mind using Excel: 1. Redesign the form in Excel from scratch, possible copying the logo or other elements from the original form (ask the bank if there are any rules about the form you use for the deposit slip). 2. Use preprinted forms and layout your Excel sheet so the relevant data will line up correctly when printed. You could have one sheet for data entry, and another for printing that just has the figures linked with formulas. 3. Insert the scanned image on a spreadsheet, and use text frame to outline the areas that need to be filled in. Uncheck the "Lock text" option under Properties for the text frame, and enable worksheet protection so everything else is locked and eneditable. I haven't tested this, but it should let you edit as desired. Not sure that there will be any keyboard navigation (tab/arrow) between fields (unless you at able to implement that with a macro, perhaps utilizing Application.OnKey - but being careful to only take over those keys when this worksheet is active). 4. Open the scanned image in a photo editing program. Turn the background transparent instead of white. Insert the image in a worksheet. You can now enter data in the regular worksheet grid. With the data in actual cells, you can use formulas either on the deposit slip or to refer to the deposit slip values, if required. The values will "show through" the deposit slip and look like they were typed ontop of the deposit slip. The truth is that the image is on top of the worksheet, though, so although tab and arrow keys will work, you can't select cells/fields on the deposit slip with the mouse (it will select the image, or if the worksheet is locked to prevent that, it will do nothing). If you take this approach, you may want to do many cell merges so that there are "cells" to take up the correct space and shape for every "field" on the deposit slip. Uncheck "Locked" under Properties/Protection for all the "field" cells, and you will be able to lock the sheet and enjoy tab/arrow between fields only. Depending on how the cells are merged, the tab order may or may not be what you want, though (possibly requiring a macro to improve the tab/arrow order). For any Excel method, a final nice touch would be to disable display of the gridlines and possibly row and column headings. I worked up an example of the fourth Excel method (using one of your deposit slips). I implemented transparency, merged cells, and unlocked appropriate cells. I left the worksheet unprotected to avoid any confusion for someone examining the workbook, but if you protect the sheet you will see how the focus is limited to the fields on the deposit slip, as well as witness the limitations to this method already described. The file size is too large for the group with the scanned image, so here are links to an XLS file and the image file after my edit. FILE>Download to download: · Deposit Slip Example.XLS <https://docs.google.com/open?id=0Bwkcc6g0MuPTU25GTDVJODE0UGs> https://docs.google.com/open?id=0Bwkcc6g0MuPTU25GTDVJODE0UGs · Deposit Slip Example.PNG <https://docs.google.com/open?id=0Bwkcc6g0MuPTMW92X3Q2N3kwNGs> https://docs.google.com/open?id=0Bwkcc6g0MuPTMW92X3Q2N3kwNGs Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ?.*:*¨¨*:*.?.*:V.Kiran Kumar :*.?.*:*¨¨*:*.? Sent: Friday, April 27, 2012 2:18 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to make using excel to print the Bank deposit slips Dear All I am having problem with bank cheque and cash deposit slips I am failing make bank cheque and cash deposit slips in excel If any body can assist me as per attached bank cheque and cash deposit slips in excel I shall be thankful Regards V.Kiran Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
