LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
prevent reading or any access to selected cells R New Users to Excel 2 August 26th 09 10:06 PM
How to prevent multi-access for XLAs? Stefano Gatto Excel Programming 1 May 21st 06 10:49 AM
Prevent Access To already open file ashtod1 New Users to Excel 0 January 5th 06 10:57 PM
How can I prevent access to code contained within Tab Lee Excel Worksheet Functions 1 September 21st 05 12:42 AM
Prevent Access To VBA Editor? Matthew John Antoszkiw Excel Programming 4 February 23rd 04 01:31 PM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"