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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I prevent access to certain cells?
Simply unprotect the sheet through code before the import and then turn it
back on. Plenty of examples here for that or just record a macro of doing what you want, then copy and paste the parts you need. -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "tcloud@lcc" wrote: 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I prevent access to certain cells?
Thanks for your reply, and I could try that, but new to programming in VB and
don't know how to go about finding the appropriate example for what I'm trying to accomplish. Can you direct me? "John Bundy" wrote: Simply unprotect the sheet through code before the import and then turn it back on. Plenty of examples here for that or just record a macro of doing what you want, then copy and paste the parts you need. -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "tcloud@lcc" wrote: 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I prevent access to certain cells?
Are you doing the importing yourself or through code? or are they doing this?
-- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "tcloud@lcc" wrote: Thanks for your reply, and I could try that, but new to programming in VB and don't know how to go about finding the appropriate example for what I'm trying to accomplish. Can you direct me? "John Bundy" wrote: Simply unprotect the sheet through code before the import and then turn it back on. Plenty of examples here for that or just record a macro of doing what you want, then copy and paste the parts you need. -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "tcloud@lcc" wrote: 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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I prevent access to certain cells?
It is a function of an add-on program by which we enter a job number, and it
returns the contents based on a pre-selected set of criteria. I created a hyperlink to access this function when the user enters the job number. However, if I have the worksheet protected, it can't import the data. I've been trying to work on a macro to unprotect, import then reprotect the worksheet, but I think I've stumbled on a workable solution. I just did data validation and created a custom bogus formula, and now it imports the data, but it can't be modified once it is imported. What I really wanted to do was if someone selected one of the imported cells, it would just redirect the location to the cell I want updated with new data. But, if I can't get that figured out, this will do. Thanks so much for getting my "thought juices" flowing and getting me to this point! :) "John Bundy" wrote: Are you doing the importing yourself or through code? or are they doing this? -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "tcloud@lcc" wrote: Thanks for your reply, and I could try that, but new to programming in VB and don't know how to go about finding the appropriate example for what I'm trying to accomplish. Can you direct me? "John Bundy" wrote: Simply unprotect the sheet through code before the import and then turn it back on. Plenty of examples here for that or just record a macro of doing what you want, then copy and paste the parts you need. -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "tcloud@lcc" wrote: 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! |
Reply |
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 |