Protecting a sheet upon closing without VBA...

[orilion]

Hello,

So, I've got this problem. I need to make sure a worksheet gets protected once the workbook is closed, which is fairly using VBA... Not when macros are disabled, however...
The user opens the file, unprotects the sheet, closes the file and... the sheet remains unprotected because the macro didn't run...

I have got no idea how to proceed...

Many thanks for any suggestions!

 

[Joe4]

What I have seen people do is highlight the data sheet that people need to work with, by default. So, just a blank sheet is displayed when they open the file.
Then, they add a few Workbook event procedures codes to the workbook.
1. Workbook_Open: unhides the data sheet(s) that they need
2. Workbook_BeforeClose: rehides the data sheets(s) and saves the workbook before closing

If you make the sheets very hidden, they will not be able to unhide and see the data sheets that they need unless they enable macros.
So essentially what you are doing is trying to render the workbook worthless unless they enable macros.
You can add some text to the blank sheet you are showing that says something like "You must enable macros on this workbook in order to work with it".

 

[orilion]

What I have seen people do is highlight the data sheet that people need to work with, by default. So, just a blank sheet is displayed when they open the file.
Then, they add a few Workbook event procedures codes to the workbook.
1. Workbook_Open: unhides the data sheet(s) that they need
2. Workbook_BeforeClose: rehides the data sheets(s) and saves the workbook before closing

If you make the sheets very hidden, they will not be able to unhide and see the data sheets that they need unless they enable macros.
So essentially what you are doing is trying to render the workbook worthless unless they enable macros.
You can add some text to the blank sheet you are showing that says something like "You must enable macros on this workbook in order to work with it".

Seems promising. Thanks!

 

[Joe4]

You are welcome.