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
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
