Have two problems: -
1) Is there any way of referencing cells on another worksheet other than using the worksheet name!cellname? My worksheet names are v. long, which makes formulas cumbersome. Is there a shorter way of referencing?
2) Is there a way of protecting the sheet name so it cannot be changed? The only way I can see is protecting the whole workbook. However, I also want to be able to add new worksheets, which protecting the workbook prevents.
Any help greatly appreciated.