Insert worksheet

K

Krish

For some strange reason, Insert worksheet in a spreadsheet is grayed and
also when I right click the worksheet tab, all I get is Select all
worksheets or view code. How do I make Excel to behave normally?

Krish
 
H

Hank Scorpio

For some strange reason, Insert worksheet in a spreadsheet is grayed and
also when I right click the worksheet tab, all I get is Select all
worksheets or view code. How do I make Excel to behave normally?
Click to expand...

Excel IS behaving normally... when a workbook has its structure
protected. Got to Tools -> Protection -> Unprotect Workbook...
 
B

Bigwheel

Is the workbook protected, perhaps? If so, select Tools, Protection,
Unprotect Workbook
 
Top