Macro to bypass pop-up box
Thanks Mike that worked!!
What if I'm opening a workboot that is locked for editing or password
protected and I want to say YES to the prompt that asks if I want to open the
workbook in read only?
"Mike H" wrote:
Hi,
application.displayalerts=false
delete your worksheet
application.displayalerts=true
Mike
"Kell2604" wrote:
Hi Guys -
I have a macro, one of the steps deletes a sheet in my workbook. This macro
will be on a server and running at a specific time each day. My problem is
the action of deleting the sheet causes excel to promt me "Am I sure I want
to delete, yada yada?". Is there a way to tell this macro to automatically
answer yes to the prompt...as a real person will not be around to answer the
question??
Thanks very much!!
Kelley
|