Convert links to result noyb <noyb[ at ]anoynomous.ca> 28.11.2005 14:30:18 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 copy>paste>values. Thanks

Re: Convert links to result "David McRitchie" <dmcritchie_xlmvp[ at ]verizon.net> 28.11.2005 17:15:53 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" <noyb[ at ]anoynomous.ca> wrote in message news:%233K4ChC9FHA.2036[ at ]TK2MSFTNGP14.phx.gbl... [Quoted Text] > 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 copy>paste>values. > Thanks