Unable to Insert new Worksheet

G

Guest

I have a spreadsheet that I have many VBA macros in. I wanted to insert a
new worksheet ( Insert | Worksheet ), but that option is greyed-out. I tried
to add a worksheet through VBA and got an error. I tried to unprotect the
workbook, but I get a password box.

I can insert worksheets into othere excel workbooks.

Is it possible that some addin has protected the workbook.
 
G

Guest

The workbook is definitely protected and yes an addin can do something like
that. That being said the addin could also be password protected.

HTH
 
G

Guest

The workbook is definitely protected. Data | Protect has an Unprotect
Workbook option. When I choose it, it presents a password dialog.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

insert worksheet shift 11 tab 2
Excel Protection 2
VBA insert column with two workbooks open 1
Controlling worksheet protection via VBA 0
Unprotect Workbook with Function 3
Programmaticlly sign and password protect a VBA Project in Excel 2 6
macro to loop thru sheets and add info 3
Macro to Insert New Worksheet 2

Top