supress prompt for named ranges when copying sheet to new workbook

N

neowok

basically i am copying 10 charts from seperate workbooks into a ne
workbook using a macro. however those 10 workbooks have the same name
ranges in each, so when it copies each chart into the new workbook i
prompts that the named ranges already exist and asks yes to use th
source one or no to use the destination one.

now none of these named ranges are relevant because i have delinked th
charts from the chart data, but because theres 3 named ranges in eac
file, i have to click yes 30 times.

im sure there must be a way to bypass the query somehow or copy th
graph without the named ranges. the code im using for copying eac
graph over is

Set snagworkbook = Workbooks.Open("list - BM1.xls", False, True)
'Set snagworkbook = Workbooks.Opensnagworkbook.Charts("Sna
DelinkChartFromData
ActiveWorkbook.Unprotect
Sheets("Graph").Move
ActiveSheet.Name = "BM1"
Set chartworkbook = ActiveWorkbook
snagworkbook.Close False

it basically opens the source book as read only, moves the graph int
the new workbook then closes the source unsaved. works fine except fo
the prompting about the named ranges
 
D

Dave Peterson

application.displayalerts = false
'do your stuff/move
application.displayalerts = true
 

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

print a chart in another workbook without opening the workbook? 1
copying to new workbook 0
Duplicate name range error when copying sheet (Excel 2010) 4
Copying Solver results of each iteration to a given location in a workbook 1
Name the range AFTER copied to new sheet 6
Using VBA to Copy Ranges to a PreSet Dim formula AND Cell Propertys. 0
how to copy worksheet to new workbook with values only 3
Copy range from multiple files in multiple folders to single sheet in master WB 10

Top