Access to hidden files

Hello,

I have an excel database that links to a sharepoint site via a number of macros.

With the workbook attached to the site - I'd like to hide all of the various libraries from the users so they will just see the home screen - while obviously allowing the macros to still access and display the various files. Essentially I need to give them read access without being able to view the library from sharepoint.