Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Insert new Worksheet
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 "Jim Zeeb" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Insert new Worksheet
The workbook is definitely protected. Data | Protect has an Unprotect
Workbook option. When I choose it, it presents a password dialog. "Jim Thomlinson" wrote: 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 "Jim Zeeb" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to insert chart | Charts and Charting in Excel | |||
Unable to Insert Columns | Excel Discussion (Misc queries) | |||
I am unable to insert, move, copy a worksheet | Excel Discussion (Misc queries) | |||
Unable to delete or insert a worksheet. | Excel Discussion (Misc queries) | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions |