Forum Discussion
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...
I solved it! The problem was in the Protect Workbook. I apparently clicked on it and then forgot I did. It does not respond with "Unprotect Workbook" like "Protect Sheet" does, so I did not know that my workbook was protected because I could work with the Sheets that were already in my file. I think this is a bug in Excel that should be fixed.