Help with Locking a column

Arcticwarrio

Active Member
Joined
Dec 6, 2005
Messages
439
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?
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Arcticwarrio

Active Member
Joined
Dec 6, 2005
Messages
439
and also is there a way to find where links between workbooks are?
i have one in there somewhere and wish to delete it
 

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
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

Active Member
Joined
Dec 6, 2005
Messages
439
i moved each sheet to a new workbook then saved and re-open the book to find the link, thanks for your help
 

Watch MrExcel Video

Forum statistics

Threads
1,118,380
Messages
5,571,796
Members
412,419
Latest member
acemali
Top