Hello,
I need a little help. I am trying to figure out a vba code to have the excel user only be able to view cells A1:H25, even if they try to change the size of spreadsheet in the lower right hand corner. So if the user wants to change the size of the spreadsheet, the cells A1:H25 will still be locked. I can freeze the panes to only show A1:H25, but if the user makes the spreadsheet larger, they are able to to see past the cells I want them to see. My end goal is if the user changes the size of the spreadsheet either larger or smaller, they will always see A1:H25. I hope this makes sense.
Thanks
Bookmarks