Canadian Tax in Spread Sheet

[vkgupta]

I have got a spread sheet from a friend which is designed to do Canadian tax. It is formatted in actual tax forms colour and texts. It has all the forms and all data entry figures with all scenerios.


Now my assignment is to create 3 print buttons:


1. Print all Forms (including Blank)

2. Print Filled up Forms only

3. Print to PDF


So Help friends.....

 

[Luke M]

Are these forms actual VB Forms, or just XL spreadsheets? Printing all spreadsheet is a simple command. CHecking for filled forms needs some sort of COUNT check to determine if cells have been filled in. Printing to PDF is controlled via printer selection. Easiest to figure out correct syntax by recording a macro of yourself changing the printer to PDF and then printing.