This is proving to be so frustrating.. I have a workbook called menu, which
has a user form. On the form there are labels which each hyperlink to a
different report;

For example;
Application.ThisWorkbook.FollowHyperlink "S:\Lists\Analysis\CVC
METRICS\Customer Metrics.xls"
Windows("Report Menu.xls").Activate
ActiveWorkbook.Close False


On each report e.g. Customer Metrics, i have a command button for returning
back to the form. How do I close, the customer metrics program oce it has
returned to teh menu becuase the userform prevents anything closing. I did
try and close it before showing userform.show but I keep getting a
application error. What is the right method?

From a previouw post of Tom Ogilvy

On error Resume next
workbooks("Customer Metrics.xls").Close SaveChanges:=False
On Error goto 0




"SEAN DI''''ANNO" wrote:

This is proving to be so frustrating.. I have a workbook called menu, which
has a user form. On the form there are labels which each hyperlink to a
different report;

For example;
Application.ThisWorkbook.FollowHyperlink "S:\Lists\Analysis\CVC
METRICS\Customer Metrics.xls"
Windows("Report Menu.xls").Activate
ActiveWorkbook.Close False


On each report e.g. Customer Metrics, i have a command button for returning
back to the form. How do I close, the customer metrics program oce it has
returned to teh menu becuase the userform prevents anything closing. I did
try and close it before showing userform.show but I keep getting a
application error. What is the right method?