I have an Excel worksheet with data linked from an Access database. I want to lock it so that no one can edit the Excel worksheet but yet the data will still update from Access. I can't figure out how to do both.
Thanks!
I have an Excel worksheet with data linked from an Access database. I want to lock it so that no one can edit the Excel worksheet but yet the data will still update from Access. I can't figure out how to do both.
Thanks!
Would a password help? If those without a password could only open the file read only it would still update from Access, but they could not save any changes they make. That may not be what you want as they could still edit the read only version they have open and save a copy for themselves, but it would keep the original intact.
Try Protecting it via coding by enabling the UserInterFaceOnly as True so that users manual access/entries can be restricted.
UserInterFaceOnly will get vanished once the workbook is closed and re-opened. You have to initiate the protection via coding every time on by adding the code in Workbook open event![]()
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks