ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   is this a bug or feature? (https://www.excelbanter.com/excel-programming/356168-bug-feature.html)

Gary Keramidas

is this a bug or feature?
 
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




Jim Cone

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





All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com