Protecting Linked Workbooks
Hello,
I have a workbook which links to a database. The workbook has multiple
sheets. The users will input the data in the workbook, and my database is
pulling the data from the workbook.
What I like to do is I like to lock the workbook so that the users can not
rename the sheets names and can not move the sheets. I tried the feature
"Protect Workbook", and when I did that, I was not able to get the data in
the database. It's saying that the workbook is protected.
Please help. Thanks.
|