Hi all,
I have a workbook in which a macro creates a new sheet, and copies over the contents of a templates sheet to the new sheet. The template has 3 links at the top. I want to make the workbook a shared workbook, and some of the limitations of shared workbooks is you can not create hyperlinks, buttons, or shapes. So I can not copy over the links from the template to the new sheet. Is there any other way to create a new sheet and get links onto it if it is shared?
I have a workbook in which a macro creates a new sheet, and copies over the contents of a templates sheet to the new sheet. The template has 3 links at the top. I want to make the workbook a shared workbook, and some of the limitations of shared workbooks is you can not create hyperlinks, buttons, or shapes. So I can not copy over the links from the template to the new sheet. Is there any other way to create a new sheet and get links onto it if it is shared?
