CLOSE WORKBOOK FROM MENU WITH USERFORM

S

SEAN DI''''ANNO

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?
 
J

JRForm

From a previouw post of Tom Ogilvy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top