ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   protected excel2003 document. Name Cell not functioning. (https://www.excelbanter.com/excel-worksheet-functions/165222-protected-excel2003-document-name-cell-not-functioning.html)

theboyles1

protected excel2003 document. Name Cell not functioning.
 
I have created a lost/found document on excel (of which each month we receive
over 200 items).
To enable us to refer back to outstanding items I like to refer back by
using the NAME cell at top left of screen (highlighting each cell then giving
it a unique name like Followup123. However, now that i have protected my
document i am unable to utilise this function without unprotecting the
document each time i want to add a new name. This is way too time consuming.

Is there any way that i can continue to use the NAME cell or do i have to
find another way of highlighting outstanding items to be followed up?
Thank you in advance..... Gee i hope there is a solution cause i've tried
everything.


All times are GMT +1. The time now is 08:45 PM.

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