ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   code for showing a sheet has been printed (https://www.excelbanter.com/excel-worksheet-functions/70463-code-showing-sheet-has-been-printed.html)

Giselle

code for showing a sheet has been printed
 
hi all

I have a workbook used in scoring wrestling competitions. There is one
worksheet for each of 10 Divisions. Each sheet has 5 form buttons that
allows the printing of 5 different reports.

I have a table on my first worksheet to keep track of what reports I have
already printed. (not PREVIEWED, but actually PRINTED) . Currently I just
enter "OK" in the appropriate cells of this table to show me which reports
I've already printed.

Is there an easy way to automate this, showing which reports have been
printed? (by code or by entering a formula in the cells)

befuddled
Giselle





All times are GMT +1. The time now is 03:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com