Help with Locking a column

[Arcticwarrio]

Hello.

I need to lock the data of a column without protecting the sheet.
the column contains formulas that add other cells.

but i need to be able to change colour etc to all other area's of the sheet.
is this possible?

 

[Arcticwarrio]

and also is there a way to find where links between workbooks are?
i have one in there somewhere and wish to delete it

 

[Arcticwarrio]

anyone?

 

[Arcticwarrio]

BUMP

 

[shajueasow]

If your Column to be protected is on the Right end, then adjusting the scroll area might help you.
For playing with links, try Edit>Links.

 

[Arcticwarrio]

i moved each sheet to a new workbook then saved and re-open the book to find the link, thanks for your help