Limiting Access to a Range (Excel 2000)

Topic

New Reply

I am needing to limit a user’s movment on a sheet to a specific range. I used to have the code for this but can’t find it…
I only want them to access range b5:e10 and not be able to move outside of that range.

Reply | Quote

Replies

Hi Bill,

I think you are looking for something like

Activesheet.ScrollArea=”a1:n40″

This prevents the user from selecting a cell outside of this area.

Reply | Quote

just a quick note here: ScrollArea needs to be reset each time you open the workbook.

HTH

Reply | Quote

This is Exactly what I was needing. Thank you! I’ve set the macro to open when the workbook opens.

Reply | Quote

As an alternative to setting a scrollarea you could hide column A and F:IV and rows 1:5 and 11:65536

Reply | Quote