make a range of cells absolute!

[barneyboy]

Hi .. I have a reference to a worksheet in another worksheet which I want to make absolute eg, in worksheet 3 I have the range =sheet2! A1:W57.
How can I make the cells in sheet 3 to be locked absolutely ($A$1:$W$57) without having to do each one individually.

Many thanks in advance.

Barneyboy

 

[Michael M]

Hi and Welcome to the Board
You'll need a macro to do this....find one here, in particular Post #6

http://www.mrexcel.com/forum/showthread.php?t=29764

 

[barneyboy]

Ok, Michael .. many thanks.

BB