I was just wondering if it was possible to open different sheets on different cells?
For Example, I want sheet 1 to open at A1 but I want sheet 2 to open at B5.
This is because the majority of cells are locked on some sheets so I want it to open on an unlocked cell.
I am using Excel 2010 and have command buttons linking each sheet.
Any help would be appreciated.
Thanks![Cool :cool: :cool:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60e.png)
For Example, I want sheet 1 to open at A1 but I want sheet 2 to open at B5.
This is because the majority of cells are locked on some sheets so I want it to open on an unlocked cell.
I am using Excel 2010 and have command buttons linking each sheet.
Any help would be appreciated.
Thanks
![Cool :cool: :cool:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60e.png)