Not allow new worksheets to be added

**katkth7533** · 11-06-2015, 04:47 PM

Hi:

I have a shared worksheet that sits on a network. It is entirely password protected so users can open it to review/ print data but not edit. I want to assure that new worksheets can NOT be added to the file so I added the code below to the Workbook_New Sheet module. It produces the message but allows the new worksheets to be added. If the file is closed, those sheets are not saved. However, if the user types something on one of the new sheets, it IS saved. Does anyone know how to prevent the worksheet from even being created? I have used this code before and it worked so not sure where I am going wrong.

Please Login or Register  to view this content.

**TMS** · 11-06-2015, 05:10 PM

Please Login or Register  to view this content.

Regards, TMS

**katkth7533** · 11-06-2015, 05:22 PM

Thank you but I was able to add the new worksheets and save them

**stnkynts** · 11-06-2015, 07:05 PM

His code works just fine for me. Are you sure you enabled Macros/put it in the correct spot?

**katkth7533** · 11-09-2015, 12:01 PM

Yes - It is placed in the "This Workbook" module of the file and the entire file has macros so it is a macro enabled file. It did not work for me with Excel 2010

**berlan** · 11-09-2015, 12:03 PM

And have you made sure that EnableEvents is turned on?

in the Immediate window (Ctrl+G) type and enter:

Please Login or Register  to view this content.

**TMS** · 11-09-2015, 12:37 PM

See the attached example. Enable macros and see if you can add a sheet. You should see a flicker as it creates and then immediately deletes it. See the Immediate Window to prove the point.

**katkth7533** · 11-10-2015, 10:35 AM

No. It still didn't work even in this file. I added and saved 2 sheets. I am trying to upload the file to show you that I didn't make any adjustments but it is taking too long for it to upload

**stnkynts** · 11-10-2015, 12:03 PM

You might want to look through your Trust Center Settings to make sure macros are enabled and there are no other conflicts. If everything is good on that end I wonder if there is something wrong with your copy of excel (seeing as how no one else is experiencing the same issue as you)