#1
|
|||
|
|||
Add worksheets to workbook
I am trying to add a new chart in a new worksheet in a protected workbook, but the "plus sign" to add a new sheet is grayed out, so I can't add the sheet.
Thanks for any help. |
#2
|
|||
|
|||
I mostly do as bellow:
It is possible to create a new sheet for you chart, if you first select the data range then go to insert chart. Select chart type then In the chart Options window select new worksheet. |
#3
|
|||
|
|||
Unprotect the sheet.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Summing data from multiple worksheets in a workbook and placing into another worksheet | safrac | Excel | 17 | 10-04-2022 12:21 PM |
I need an index file containing the names of all the worksheets in a workbook. | retiredstuart | Excel | 3 | 09-12-2014 06:26 AM |
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
macro to transfer data from one workbook to another workbook | virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
Select a range in one one workbook while working in other workbook | Slow&Steady | Excel | 1 | 02-21-2010 03:34 AM |