Hi all,
I have a small macro in one workbook that open another workbook in memory :
dim xls as workbook
set xls = application.excel
xls.open "c:\..."
everything works fine, but on the opened workbook in memory I am deleting some sheets and saving at the end and I would like to get rid of the windows alerts asking if I'm sure I want to delete the sheets and saving
I tried :
application.displayAlerts = false
xls.displayalerts = false
but It's keeps showing me the alert ...
any suggestions would be appreciated