View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Zeeb[_2_] Jim Zeeb[_2_] is offline
external usenet poster
 
Posts: 23
Default Unable to Insert new Worksheet

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.