| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying sheets with pictures
Hi,
I have a worksheet which contains quite a lot of information, including many VBA buttons, pictures and 59 charts. I have turned off Auto font size for charts in the Windows register, because otherwise it complained that I had too many fonts. I want to make 36 copies of this worksheet in the same workbook, but when I try to copy it, all the VBA buttons, pictures and charts are missing in the new spreadsheet! Neither copying via the Edit menu, or selecting everything and copying with ctrl+C works. What should I do? Thank you, Sebastian |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying sheets with pictures
Right click on the sheet's tab and choose Move or Copy. Check the Make a
copy box. Repeat as needed "Seb" wrote: Hi, I have a worksheet which contains quite a lot of information, including many VBA buttons, pictures and 59 charts. I have turned off Auto font size for charts in the Windows register, because otherwise it complained that I had too many fonts. I want to make 36 copies of this worksheet in the same workbook, but when I try to copy it, all the VBA buttons, pictures and charts are missing in the new spreadsheet! Neither copying via the Edit menu, or selecting everything and copying with ctrl+C works. What should I do? Thank you, Sebastian |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying sheets with pictures
That doesn't work.
Sebastian "Duke Carey" skrev: Right click on the sheet's tab and choose Move or Copy. Check the Make a copy box. Repeat as needed "Seb" wrote: Hi, I have a worksheet which contains quite a lot of information, including many VBA buttons, pictures and 59 charts. I have turned off Auto font size for charts in the Windows register, because otherwise it complained that I had too many fonts. I want to make 36 copies of this worksheet in the same workbook, but when I try to copy it, all the VBA buttons, pictures and charts are missing in the new spreadsheet! Neither copying via the Edit menu, or selecting everything and copying with ctrl+C works. What should I do? Thank you, Sebastian |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying sheets with pictures
Define 'doesn't work'
"Sebastian" wrote: That doesn't work. Sebastian "Duke Carey" skrev: Right click on the sheet's tab and choose Move or Copy. Check the Make a copy box. Repeat as needed "Seb" wrote: Hi, I have a worksheet which contains quite a lot of information, including many VBA buttons, pictures and 59 charts. I have turned off Auto font size for charts in the Windows register, because otherwise it complained that I had too many fonts. I want to make 36 copies of this worksheet in the same workbook, but when I try to copy it, all the VBA buttons, pictures and charts are missing in the new spreadsheet! Neither copying via the Edit menu, or selecting everything and copying with ctrl+C works. What should I do? Thank you, Sebastian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying charts into new sheets, data is pulled from old sheet | Charts and Charting in Excel | |||
| copying the same cells from many sheets | Excel Worksheet Functions | |||
| Copying only report sheets | Excel Discussion (Misc queries) | |||
| Copying Sheets causes errors | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Linear Mode
