It appears that when you link a cell in one worksheet to a cell in another worksheet, the contents of the cell are not protected. It is possible to change the contents of the second cell so they no longer reflect the contents of original cell. I know one can protect the whole sheet but that is inconvenient. Is it possible to lock just the cell with the link?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Protecting Linked Cells
- Thread starter dibeach
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
The default for workbooks is to have all cells locked but not protected. You could select all the cells (probably most of the sheet by the sound of it, which may be a bit of a pain) that need to remain editable, unlock them (format menu>cells>protection and uncheck the 'locked' check box) leaving your linked cells the only ones that are still locked. Protecting your worksheet will then only affect the cells that are still locked.
There's probably also a clever VBA method which is less laborious than this.
By the way, forum moderator, someone's stolen my handle. I was posting as a visitor using 'scat' as a handle. When trying to post this answer i was told that a member was now using that name. What's the story?
There's probably also a clever VBA method which is less laborious than this.
By the way, forum moderator, someone's stolen my handle. I was posting as a visitor using 'scat' as a handle. When trying to post this answer i was told that a member was now using that name. What's the story?
I'm no moderator but Visitor names are not permanent - if you want to keep a handle....join up. It costs nothing and AFAIK, if you choose to receive no "mail" you get none - I've been a member for several months now and I havn't received a single bit of spam Rgds
~Geoff~
~Geoff~
Guest_imported
New member
- Jan 1, 1970
- 0
xlbo
thanks for the info. the spam thing was a bit of a concern - i've been getting it since i've joined a couple of other boards.
btw, any thoughts on dibeach's problem? what i've suggested will work but it's pretty clunky. i don't know any vba but i see from your profile that you've been doing it for a couple of years.
regards
cats
thanks for the info. the spam thing was a bit of a concern - i've been getting it since i've joined a couple of other boards.
btw, any thoughts on dibeach's problem? what i've suggested will work but it's pretty clunky. i don't know any vba but i see from your profile that you've been doing it for a couple of years.
regards
cats
Well, to unlock all cells in a worksheet, you can use
Activesheet.cells.locked = false
Then you just have to lock the ones you want protected
The manual way is to click on the little grey box between "A" and "1" and choose Unlock
However, it sounds like dibeach's problem is that he doesn't want the links to update ???
ie once the value has been returned, it should not chnage , whether or not the value in the linked workbook changes......dibeach, am I correct ?? Rgds
~Geoff~
Activesheet.cells.locked = false
Then you just have to lock the ones you want protected
The manual way is to click on the little grey box between "A" and "1" and choose Unlock
However, it sounds like dibeach's problem is that he doesn't want the links to update ???
ie once the value has been returned, it should not chnage , whether or not the value in the linked workbook changes......dibeach, am I correct ?? Rgds
~Geoff~
- Status
Similar threads
- Locked
- Question
