So I currently have 2 excel files that are identical and file 1 is where data gets entered and it feeds file 2. What I am wondering is it possible to lock a cell in either file once the data has been entered and saved? I am trying to avoid any potential for data in file 1 being deleted by having it locked either in file 1 or 2.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
dUBBINS
Well-known Member
- Joined
- Feb 9, 2015
- Messages
- 504
The only thing I can think of is to use a worksheet change event (VBA); however, that could easily make your spreadsheet very slow if we are talking large amounts of cells.
What are you trying to solve exactly? In that, are you worried that you will accidently erase it, that a coworker will accidently erase it, someone will erase it on purpose, etc.
What are you trying to solve exactly? In that, are you worried that you will accidently erase it, that a coworker will accidently erase it, someone will erase it on purpose, etc.
Upvote
0
Its function is to serve as a tracking log for when employees work in other departments they can enter that time onto their spreadsheet which is on a department drive and it feeds to the managers file on their personal drive at which point the manager can track all workings in other departments. The concern is that either accidently or intentionally that data may get deleted, changed after its initial entry, so my hope was that once the data is entered and saved initially that it would be able to lock either on the front end or back end so that the employee will get the credit due.
Upvote
0
dUBBINS
Well-known Member
- Joined
- Feb 9, 2015
- Messages
- 504
Ah.
If I were trying to do that, I would write code that copied/pasted the information, rather than using a formula. Then make a submission button that the user presses after entering their time.
Do you ever write in VBA? If not, tell me what columns are being used, what the first cell address is in each of said columns, and what the workbook(s)/worksheet(s) are named. I will write you something, this is pretty quick.
If I were trying to do that, I would write code that copied/pasted the information, rather than using a formula. Then make a submission button that the user presses after entering their time.
Do you ever write in VBA? If not, tell me what columns are being used, what the first cell address is in each of said columns, and what the workbook(s)/worksheet(s) are named. I will write you something, this is pretty quick.
Upvote
0
The columns of use are B- N, then within each column its broke down into sections of 4 rows. For example Employee A will populate cells B2-B4 for one month then cells C2-C4 for the next month. There are 59 employees in column A and each employees row(s) consists of the 4rows starting with B2-B4. Let me know if this makes sense or not, I'm trying to attach the file or at least a screen shot to help explain, but am having no success.
Upvote
0
Similar threads
- Question
