View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default is this a bug or feature?

Hi Gary,
It's new to me.
I tested it and found also that the protected cell works like
a hyperlink, if the second workbook is open.
Jim Cone
San Francisco, USA


"Gary Keramidas" <GKeramidasATmsn.com wrote in message ...
always wondered if this was by design or not.
say i have a summary workbook with link to another workbook

in A1 of summary.xls:
=Gary.xls!Feb_Profit

when i double click the cell when the cell is protected, i get the protected
cell warning, clicking ok then opens that workbook.
just curious
Gary