If macros are disabled, then kick out the user...

[j9]

Is there a way to do this?

 

[dsi]

If you want to prevent the user from modifying the workbook, you can hide all but one of the sheets on closing the workbook. Then, they will have to enable macros to see the sheets. You will have to leave at least one sheet visible (maybe a blank sheet?). If you set the sheets' visibility to xlVeryHidden, they will not show up in the list for unhiding sheets. The only way they could access them would be to enable the macros.

Sub Auto_Close
    'set the sheet to xlVeryHidden
End Sub

Sub Auto_Open
    'set the sheet to xlVisible
End Sub
[code]
Hope this helps!