Automatically print linked documents

How can I program a radio button or a check box to automatically print a
linked document.

In other words, if the radio button is selected, and I print the Excel
spreadsheet, I want it to automatically print the file that it is linked to.
But only if the radio button is selected. If the radio button is not
selected, I don't want it to print to the linked document.

Thanks

EnglishTeacher wrote:
In other words, if the radio button is selected, and I print the Excel
spreadsheet, I want it to automatically print the file that it is linked to.
But only if the radio button is selected. If the radio button is not
selected, I don't want it to print to the linked document.


You will need to write a macro that gets executed when the worksheet is to be
printed.

The only suitable event is Workbook_BeforePrint which is called regardless of
the print options you have chosen (active sheet, whole workbook etc). Can I
assume that whenever you print anything in the workbook you want to take
account of the checkboxes?

Radio buttons are appropriate if you only ever select one of the linked files
to print - otherwise checkboxes are more suitable. Can I assume checkboxes?

You can't print a workbook without opening it. You won't be able to open the
workbook if there is a workbook with the same name. Can I assume that if there
is a workbook open with the same name then that is the one you want to print?

I want it to automatically print the file that it is linked to.

This sounds like the checkbox is linked to the file (ie the setting of the
checkbox comes from the linked file). Is that the case?
If not, how would we find the filename starting from the checkbox?

If you would care to answer these questions we could probably suggest some code
to do what you desire.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Sorr, Bill for the delay in the response. I was away from my desk on a
three-day weekend starting last Friday.

In response to your questions:

1. Yes. Whevenever the main workbook is printed, it should and will take
account of the checkboxes

2. Yes, checkboxes will be better because there is likely to be multiple
other files that will be linked, opened and printed.

3. Yes, you can assume that if there is a workbook open with the same name
then that is the one you want to print.

4. Yes, the checkbox is linked to the file. Can you show me how to do that
as well?

Thanks.

"Bill Manville" wrote:

EnglishTeacher wrote:
In other words, if the radio button is selected, and I print the Excel
spreadsheet, I want it to automatically print the file that it is linked to.
But only if the radio button is selected. If the radio button is not
selected, I don't want it to print to the linked document.


You will need to write a macro that gets executed when the worksheet is to be
printed.

The only suitable event is Workbook_BeforePrint which is called regardless of
the print options you have chosen (active sheet, whole workbook etc). Can I
assume that whenever you print anything in the workbook you want to take
account of the checkboxes?

Radio buttons are appropriate if you only ever select one of the linked files
to print - otherwise checkboxes are more suitable. Can I assume checkboxes?

You can't print a workbook without opening it. You won't be able to open the
workbook if there is a workbook with the same name. Can I assume that if there
is a workbook open with the same name then that is the one you want to print?

I want it to automatically print the file that it is linked to.

This sounds like the checkbox is linked to the file (ie the setting of the
checkbox comes from the linked file). Is that the case?
If not, how would we find the filename starting from the checkbox?

If you would care to answer these questions we could probably suggest some code
to do what you desire.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup