View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian Pellew Ian Pellew is offline
external usenet poster
 
Posts: 1
Default How to deal with an error question

Hi all;

How do I catch an error on
ChDir "C:\Documents and Settings\me\Desktop"
Workbooks.Open Filename:="Some_file.xls"
?
If the some_file.xls is cancelled ( because it is password protected )
I get a "run time error" from the debugger.

So how can I deal with this in a proper manner?

Regards
Ian