hungledink
Board Regular
- Joined
- Feb 20, 2012
- Messages
- 88
- Office Version
- 365
I was wondering if someone could provided some assistance in a project I've been asked to look at for work.
Essentially, I want to create 2 workbooks. One will be a database, that just stores data, and the second will be an input sheet, where users will add data that gets added to the database. I want to keep the database separate to maintain the integrity of the data
I'd like to make it so that the database can only be opened and viewed by a button on the input sheet workbook. This will then switch to the database file where they can view the desired info, and then switch back.
I do know a bit of vba so I can get the database to open when the input sheet is open, but then have it hidden. I've also got the buttons working to switch between the files.
The problem I'm having is how to stop the database file being opened as a standalone workbook.
Can anyone advise? Its something I'm working on at work so unfortunately can post the existing code.
Essentially, I want to create 2 workbooks. One will be a database, that just stores data, and the second will be an input sheet, where users will add data that gets added to the database. I want to keep the database separate to maintain the integrity of the data
I'd like to make it so that the database can only be opened and viewed by a button on the input sheet workbook. This will then switch to the database file where they can view the desired info, and then switch back.
I do know a bit of vba so I can get the database to open when the input sheet is open, but then have it hidden. I've also got the buttons working to switch between the files.
The problem I'm having is how to stop the database file being opened as a standalone workbook.
Can anyone advise? Its something I'm working on at work so unfortunately can post the existing code.