View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AccessHelp AccessHelp is offline
external usenet poster
 
Posts: 213
Default 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.