View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brent Brent is offline
external usenet poster
 
Posts: 109
Default Linking worksheets (Security)

Hello,

I have created two workspaces. One workspace is for the user to enter data.
The other workspace contains sensitive data and also calculates data that is
transfered back to the "user" workspace. The two files will be located on
the users' notebook computer (offline).

I was hoping to password protect the "master" workspace and have it hidden
on the notebooks. However I can't seem to get any data transfer unless both
files are open........is there a way to do what I want and keep the master
workspace closed?

Thanks!