LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Giselle
 
Posts: n/a
Default 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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
AUTO FILTER NOT CHANGING RESULTS Dejan Excel Discussion (Misc queries) 25 October 6th 05 02:01 PM
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM
how do i create an access code sheet to number my office files an. dana New Users to Excel 1 February 12th 05 03:49 AM
how can i select all the cells with same color on a sheet if there are multipale colors by vba code uobt Charts and Charting in Excel 1 December 15th 04 05:27 PM


All times are GMT +1. The time now is 01:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"