Excel protection and links

Copper Contributor

I have an Excel workbook (a template)  with 8 sheets containing links to another workbook. I have to remove the link after I have updated the new workbook once. All the sheets have to be protected so that people can´t change the formulas. How can I protect all the sheets once so that I don´t have to go to every sheet. I don´t use passwords.

2 Replies
You cannot, other than by using a small macro.

I knew it...

I found another solution to the problem.

Thanks,

 

Tellu

 

@Jan Karel Pieterse