I have an Excel workbook that is used by numerous individuals across the province via our server. For this workbook to function properly, I need each user to choose "Enable Macros" upon opening the workbook. However, they are still able to access the workbook regardless of their decision. Is there a way to prevent the users from viewing/editing/etc the workbook if they choose to "Disable Macros"? Possibly through some sort of conditional formatting? Or....??
Thanks.
Bookmarks