I found the previous post with the disclaimer code and it's what I would like to use BUT the problem I have is if the user has Macros disabled the data in the excel sheet still is viewable. Is there a way to make it so that if they have the Macros disabled they get nothing?

Basically I need a file to open and they have to accept to enter the document, if they decline or X out of the disclaimer it closes the document.

The trick is, if they have their excel environment set to disable macros my disclaimer is not showing up and all the data in the excel file is viewable.

Anybody know how I can fix this?