New Workbook "There is already data here. Do you wish to replace it?"

[Rickinnocal]

Hi, I have a button that creates new Sheets in a new Workbook.

When I click it, a MsgBox asks for a filename. If I enter a filename that exists, as expected I get "File already exists do you wish to replace it?"

Whether I use a pre-existing file name and click "yes", or I use a new filename, as each new sheet opens I get a message box "There is already data here. Do you wish to replace it?"

This is a new worksheet in a new workbook. Why would there already be data there? Is there any way to tell Excel to just ignore this?

 

[Zot]

Hi, I have a button that creates new Sheets in a new Workbook.

When I click it, a MsgBox asks for a filename. If I enter a filename that exists, as expected I get "File already exists do you wish to replace it?"

Whether I use a pre-existing file name and click "yes", or I use a new filename, as each new sheet opens I get a message box "There is already data here. Do you wish to replace it?"

This is a new worksheet in a new workbook. Why would there already be data there? Is there any way to tell Excel to just ignore this?

See if this helps

How to disable "There's already data here. Do you want to replace it?" warning - Excel Macros

When you drag any cell with data and drop it on any other cell with data, you will get the warning, "There's already data here. Do you want to replace

www.excelhowto.com