LinkBack URL
About LinkBacks
I have a spreadsheet with formulas that autofill the cells they're in. I would like to protect those cells, so that users don't change them by mistake, but when I protect them, they don't autofill anymore... how can I do this? Thanks!
I have a spreadsheet with formulas that autofill the cells they're in. I would like to protect those cells, so that users don't change them by mistake, but when I protect them, they don't autofill anymore... how can I do this? Thanks!
What do you mean? Locked cells containing formulae continue to work whether the sheet is protected or not, so what do you mean by 'autofill'?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
@fillipa, is your spreadsheet a Table?
sorry, my mistake, solved!Originally Posted by AliGW
no, @ohhaa, but it's solved, it was my mistake. thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks