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