Forum Discussion
import data to a protected worksheet
Hey!
There often are very good and lasting reasons to protect a spreadsheet and its formulas. Presumably this was created by somebody other than yourself (or else you'd be able to unprotect it and not need to ask).
Do you need to import specifically into the very worksheet that is protected? Why not into a second (or third, whatever; a separate) worksheet in the same workbook. You can still access it and use the data.
Is it possible to share the actual sheet, just rendering anonymous any confidential or proprietary data on it?
Hello!
Thanks for your answer.
Yes it was created by my colleague and it has some very complex formulas, that need to be protected from other users.
The reason why I want to import to this sheet directly, is because it is set up with another sheet, to calculate limits, do lookups etc.
After giving it some thought, I think you are right. I will have to set up a new sheet, in which the data can be imported, followed by a macro button, which will copy paste it into the protected sheet.
Do you have any other ideas to get imported data from a sheet into another sheet, other than creating a macro?
I don't think I am allowed to do so, no 🙂