Unable to Insert new Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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

How to bypass password when pasting FROM a protected workbook 3
insert worksheet shift 11 tab 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Programmaticlly sign and password protect a VBA Project in Excel 2 6
macro to control tabs (different worksheets) 8
Unprotect Workbook with Function 3
VBA insert column with two workbooks open 1
Excel Highlighting duplicates 0

Back
Top