Hi All,
I have a workbook, which others besides me would be using.
CHEQUE REGISTER is the name of the sheet containing financial data. Column B contains cheque numbers and Column U contains cheque amounts in words.
Cells B6 to Q6, of sheet named Cheque Template, are merged and have a (combined) width of 72. It is formatted as @**, and contains the following formula:
=IF(ISERROR(IF(VLOOKUP($S$3,'CHEQUE REGISTER'!$B$4:$U$10001,20,FALSE)="","",VLOOKUP($S$3,'CHEQUE REGISTER'!$B$4:$U$10001,20,FALSE))),"",IF(VLOOKUP($S$3,'CHEQUE REGISTER'!$B$4:$U$10001,20,FALSE)="","",VLOOKUP($S$3,'CHEQUE REGISTER'!$B$4:$U$10001,20,FALSE)))
Page Setup Scaling is set to Adjust to 100 % normal size.
When the formula copies a large amount, for example: Seven Hundred Seventy Seven Thousand Seven Hundred Seventy Seven Dollars and Seventy Seven Cents*********, the cell displays ###############. (Note: I am using font size 10.)
So, in order to prevent a cheque from being printed with ############### instead of the amount in words, I want to force the user to do a print preview, decrease the font size, if necessary, and before he/she can print the cheque.
In short, this is what I am trying to achieving:
1. Disable print on sheet named Cheque Template
2. Click a custom button to print
3. Show print preview
4. Question: OK to print?
5. If Yes, print
6. If No, show message “Please make the necessary adjustments and try again”)
7. Close button
I realize that this can only be done with VBA code so I am seeking someone to write it for me.
Help, anyone?
Thanks,
Gos-C
Bookmarks