Adding hyperlink in Shared Workbook using VBA

[144725]

I am preparing a template workbook.
Whenever a new sheet is inserted in the workbook, my macro should

1) Copy first few rows from the Template sheet (its VeryHidden) and paste in the new sheet
2) Create Data Validation for few columns
3) Create a hyperlink for the new sheet in "Links" sheet

My code works fine when the workbook is not shared. However, if it is shared, it fails while creating hyperlink & Data Validation.

Is there any workaround for this? Or i have to bare with it?

 

[Andrew Poulsom]

From Excel Help:

In a shared workbook, you cannot do the following:

<LI class=LB1>Set up or change data validation restrictions and messages. However, you can see the effects of restrictions and messages that were set up before you shared the workbook.
<LI class=LB1>Insert or change charts, pictures, objects, or hyperlinks.