I have a workbook containing a few wsheets, and once I supply the code to the (This Workbook), the code works fine. As an FYI, the code's objective is to lock the scroll areas on each sheet. When I email this file to another user, the code isn't working. This is mainly due to their security settings, which are set to not allow macros. Is there a workaround to this? My wants or needs are this, when the user opens the file, the scrolling areas I set in VB will work seamlessly.

I was thinking along the lines of creating a macro to "freeze or lock" the entire workbook, and the user will have to follow instructions to enable macro security properly. What this really boils down to is that I want to maintain the aesthetics of the design.


While I am in here, and being a separate issue, when I look in the editor, it seems that vba projects keep adding on top of another, and I cannot delete these in the editor. I have to delete these files in the directories and start over again. When I start saving a file, somehow it adds yet another vb project (same file name). Weird. Any ideas?

Thanks!


Private Sub Workbook_Open()
Worksheets("Main").ScrollArea = "A1:AL115"
Worksheets("1st Qtr").ScrollArea = "A1:Ar130"
Worksheets("2nd Qtr").ScrollArea = "A1:Ar130"
Worksheets("3rd Qtr").ScrollArea = "A1:Ar130"
Worksheets("4th Qtr").ScrollArea = "A1:Ar130"
Worksheets("REP HOURS").ScrollArea = "A1:Ar130"
Worksheets("UNION ARTICLES").ScrollArea = "A1:M40"
Worksheets("UNION REPS").ScrollArea = "A1:S80"
Worksheets("L1458 Stewards").ScrollArea = "A1:Q60"
End Sub