View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xlmaven xlmaven is offline
external usenet poster
 
Posts: 2
Default Worksheet Delete method's dialog box

The Microsoft documentation states that the delete method for a
worksheet object issues a boolean False if a user clicks Cancel on the
dialog box that gets generated warning that data may be lost if the
worksheet is deleted. How can the return value from this dialog box
be examined in VBA? I get compile errors when I try examine
worksheetname.Delete directly.