Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I prevent access to certain cells?
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent reading or any access to selected cells | New Users to Excel | |||
How to prevent multi-access for XLAs? | Excel Programming | |||
Prevent Access To already open file | New Users to Excel | |||
How can I prevent access to code contained within Tab | Excel Worksheet Functions | |||
Prevent Access To VBA Editor? | Excel Programming |