How to maintain scroll area and also protect sheet

[ACrossley1]

Hi.

I have been locking the scroll using the vba and it works great. However, when i 'protect sheet' it stops the scroll lock.

How do i do both, set a certain scroll area and also protect the sheet so other users can not delete or move graphs?

Thanks.
Adam.

[6StringJazzer]

How have you been locking the scroll with VBA?

[ACrossley1]

Hi.

I have been right clicking on the tab at the bottom of the worksheet and then typing in 'scrollarea' the area i want to stop eg a1:v40.

Do you think this is possible to achieve?

[6StringJazzer]

I have been right clicking on the tab at the bottom of the worksheet and then typing in 'scrollarea' the area i want to stop eg a1:v40.

Sorry, I don't know what this means. You said you were using VBA. Please show the VBA code you are using.

[mikerickson]

If you are concerned about the user scrolling to see cells that they shouldn't, you could keep those cells hidden.

[Logit]

.
I'm not experiencing the problem you have described.

I did some searching and found this resource. Maybe this will help you.

http://dailydoseofexcel.com/archives...tected-sheets/

[ACrossley1]

Hi.

Thank you for the responses.

Yeah everytime i right click and type in the scrollarea the area i want to only show, and then i lock the worksheet it stops the scrollarea lock from working.

Not sure how to stop this?