Limit Scroll area VBA & Macro Security

Hi All and Merry Christmas!

I have inserted some vb code into my workbook that limits the scroll area on all worksheets with no problems. However, as I intend to distribute this workbook, it was my understanding that the user would see a pop up asking to enable macros when you opened an (.xlsm) file. I emailed this file to myself last night, and when I arrived to work and opened this file, no mention of security popped up. So I continued to see if the vb code I implanted was still working, and it was not. So I went to Macro Security, and saw that it was set to disable all macros. I enabled macros, saved, closed, reopened the file, and then the vb code worked.

To reiterate, the problem I have with this, is when an unknown user in the agency receives this file, they will not know to enable macros. Is there anyone that has code or any idea on how to disable use of this workbook until the macro security has been enabled? Otherwise, my scroll areas will never be locked. For those that don't know, when you set your scroll area in the VB Editor (properties), this works just fine when the file is still open. However, when you close this file and reopen it, the scroll area you wanted will be gone. This is why I used some vb code to stop this. But now today, I learn that this is still not working because the user (has to know) to enable macros. So I need the workbook to tell the user, sorry charlie, will not work for you until you enable macros first, with a big tongue sticking out. Thanks!

Hi colarguns,
maybe so
It is assumed that your data is on Sheet1 and Sheet2
Try to open the file (attached) with the enable macros and disable macros mode.
Look also code in the ThisWorkbook module

Hi Nilem, Thanks for your input. I apologize, but I cannot download for some reason. Must be a glitch on my end. Thanks though!

Hi Shg. Yes, you're right. Then maybe so

Please Login or Register  to view this content.

Hi colarguns. Try this link

Originally Posted by nilem

Hi Shg. Yes, you're right. Then maybe so

Please Login or Register  to view this content.

Hi colarguns. Try this link

This code worked great. Can you please explain the below code:

Please Login or Register  to view this content.

I am trying to understand the below code and have added in some comments:

Please Login or Register  to view this content.

When I click save, I don't want the pages to be hidden, which line of code is making this happen??

Thanks