Forum Discussion
aekbus
Jan 20, 2026Brass Contributor
Cannot add a worksheet to my Excel spreadsheet
I haver all of a sudden lost the ability to add worksheets to my spreadsheet program. I am using macros that both protect and unprotect the sheets that are currently there, but I want to add another sheet, and the plus sign at the bottom is grayed out as well as the 'Insert Line' line when you do Home/Insert. I have looked and I cannot find the setting that controls the addition of worksheets. Any suggestions???
3 Replies
- Detlef_LewinSilver Contributor
Close the workbook without saving it.
Then re-open the the workbook.
- aekbusBrass Contributor
Tried that. Doesn't work.
- Detlef_LewinSilver Contributor
Then close Excel and start again.