I have a workbook situation where my users need to be able to import cost
data to the spreadsheet, but not access it once it is imported. I have set
up a field for them to make entries to that will write back to my original
data, and that's all they should be able to access in one worksheet. Other
worksheets would have different access limitations, but I can accomplish what
I need with them through worksheet protection. My problem is that if I
"protect" the appropriate cells in my worksheet, I can't import the data,
because the area to be imported is protected. Is there a workaround? I'm
not a
VB guru, so go easy on me, please!