Convert links to result
 

I am looking for a way to convert linked cells to their actual (fixed)
values in a workbook which is password protected except for the cells I
use for linking. Would need macro which would find all non-protected
cells and do something like copypastevalues.
Thanks

Convert links to result
 

Record a macro,
do what you want, like supply password, make your changes, protect with password again

you will see the code you need.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"noyb" wrote in message ...
I am looking for a way to convert linked cells to their actual (fixed)
values in a workbook which is password protected except for the cells I
use for linking. Would need macro which would find all non-protected
cells and do something like copypastevalues.
Thanks