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!

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!

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!

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!

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!