L
LMB
Hi,
We are using Office 2000.
We have an excel workbook with our competency check off sheets. Each Sheet is a different competency. Now we are putting education modules together using power point. At the end of the education module on the last slide, we want to have a link to a specific sheet from the excel workbook so the user can print that out to do their competency. I can link to the workbook but it doesn't appear that I can link to a sheet from the workbook. Is there a way to separate all the sheets at once and make them all separate files? I think we want to keep them all in the workbook as well but I know the problems of having two sheets that are identical is not a good idea since you have to update them both.
If you have another solution or know of a way to link to a sheet in a file, I would be grateful.
I am planning on posting this on the Power Point group too.
Thanks,
Linda
We are using Office 2000.
We have an excel workbook with our competency check off sheets. Each Sheet is a different competency. Now we are putting education modules together using power point. At the end of the education module on the last slide, we want to have a link to a specific sheet from the excel workbook so the user can print that out to do their competency. I can link to the workbook but it doesn't appear that I can link to a sheet from the workbook. Is there a way to separate all the sheets at once and make them all separate files? I think we want to keep them all in the workbook as well but I know the problems of having two sheets that are identical is not a good idea since you have to update them both.
If you have another solution or know of a way to link to a sheet in a file, I would be grateful.
I am planning on posting this on the Power Point group too.
Thanks,
Linda