Just rolled out a new Private View and views which contain a sub calling a Script Library. Appears that when people open the database, they get the No Sub or Function error. Not sure why this is happening. The only way I have found to take care of it is to delete the db, which will delete the old Private View then add the database back, but instead of being able to just open the db and everything work, they have to do View-Go To and select a view then open the views individually. The problem goes away after this.
The issue does not occur on all servers. Any thoughts would be appreciated.