Gringoire
Board Regular
- Joined
- Nov 18, 2016
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
Hello guys,
I createdan Excel file where some Sheet is protected/filled/formatted by VBA code.
This is to prevent the user to introduce inconsistent data, modify layout, etc...
Everything works fine if the user accept the standard application request to enable the macro in the workbook.
If the user refuses to enable the macro, the Sheets are still shown but macro are not executed and some sensible data, formatting, etc remains totally unprotected.
How can I prevent someone to open the excel file (or at least the Sheets with sensible data) if he refuses to enable the macro? I haven't found any tip on the internet...
thank you.
I createdan Excel file where some Sheet is protected/filled/formatted by VBA code.
This is to prevent the user to introduce inconsistent data, modify layout, etc...
Everything works fine if the user accept the standard application request to enable the macro in the workbook.
If the user refuses to enable the macro, the Sheets are still shown but macro are not executed and some sensible data, formatting, etc remains totally unprotected.
How can I prevent someone to open the excel file (or at least the Sheets with sensible data) if he refuses to enable the macro? I haven't found any tip on the internet...
thank you.