The best solution I can come up with, would be to make all your sheets XLVeryhidden, and have the workbook_open event unhide these.
If the user disables macro's, no worksheet will be visable, if they press enable macro's the sheets will be visable.
HTH
Cal