Linking EXCEL WORKBOOKS
 

I need help setting up a security workbook to be opened by
other workbooks using VBA in Excel.

The "Security check" workbook will check what information
a user is allowed to view from the original workbook.
The "security check" workbook contains a userform for
entry of password. Base on the password, variable values
will be set to the original workbook for further
processing.

Linking EXCEL WORKBOOKS
 

You can do that with just the one workbook. What kind of help did you
have in mind? - Pikus


---
Message posted from http://www.ExcelForum.com/

Linking EXCEL WORKBOOKS
 

If the user disables macros, I guess they can view whatever they want.

--
Regards,
Tom Ogilvy


" wrote in message
...
I need help setting up a security workbook to be opened by
other workbooks using VBA in Excel.

The "Security check" workbook will check what information
a user is allowed to view from the original workbook.
The "security check" workbook contains a userform for
entry of password. Base on the password, variable values
will be set to the original workbook for further
processing.