Bill_Henry
New Member
- Joined
- Oct 16, 2006
- Messages
- 2
I have a workbook that has many cells hyper linked to other excel files.
In one instance, Column R has Files Hyperlinked to 20 cells in rows 5 to 52, Column S has 21, T has 22 and so on.
This would be one section of five that have the same basic format. Random linked files in set columns and rows.
Is there a command that can print the hyperlinked worsheets?
I looked at recording a macro. I made some gains, but was too time consuming. It would open each page, print. This seems to be improper for my task.
I basicaly have a schedule of tasks in 5 sections. Each section has a prescribed number of tasks set (per week) I would like to be able to print these off by runnig batch printings of the files hyperlinked in these rows. By section or by week for all 5 sections at once.
I would appreciate any assistance. I read throughout the board for a while and was unable to narrow down any definate solution. Perhaps I am asking too much.
Thanks in advance
Bill
In one instance, Column R has Files Hyperlinked to 20 cells in rows 5 to 52, Column S has 21, T has 22 and so on.
This would be one section of five that have the same basic format. Random linked files in set columns and rows.
Is there a command that can print the hyperlinked worsheets?
I looked at recording a macro. I made some gains, but was too time consuming. It would open each page, print. This seems to be improper for my task.
I basicaly have a schedule of tasks in 5 sections. Each section has a prescribed number of tasks set (per week) I would like to be able to print these off by runnig batch printings of the files hyperlinked in these rows. By section or by week for all 5 sections at once.
I would appreciate any assistance. I read throughout the board for a while and was unable to narrow down any definate solution. Perhaps I am asking too much.
Thanks in advance
Bill