ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't add worksheets to a workbook. (https://www.excelbanter.com/excel-discussion-misc-queries/199876-cant-add-worksheets-workbook.html)

MCorn

Can't add worksheets to a workbook.
 
Hi,
I have a workbook that I was able to add worksheets to and for some reason I
can't add worksheets or rename current sheets any more. There has never been
any protection added to the workbook. Does anybody know what has been done or
happened to the workbook and know how to fix it?
Thanks for any help!
MCorn

Dave Peterson

Can't add worksheets to a workbook.
 
It sure sounds like your workbook is protected.

In xl2003 menus, I'd look under:
tools|Protection

If you see "Unprotect Workbook", then your workbook is protected and you may
need a password to unprotect it.



MCorn wrote:

Hi,
I have a workbook that I was able to add worksheets to and for some reason I
can't add worksheets or rename current sheets any more. There has never been
any protection added to the workbook. Does anybody know what has been done or
happened to the workbook and know how to fix it?
Thanks for any help!
MCorn


--

Dave Peterson


All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com