When running workbook.close True Excel generates an error!!!

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

I have a big problem!

I have a "meny sheet" with al ot of controlbuttons that links to other
workboks. When a user want to see a chart placed in another book, he
uses a userform to get there. The problem comes when he presses the
"Exit" button placed on this chart sheet!

The button runs the code
Activeworkbook.close true

and after he saved it and closed the book the whole excel generates an
error wich shut down excel!! This is not good if users work with other
book at the same time!

Anyone got a clue whats wrong??!

Daniel
 
Hi Daniel,

Just an idea, as you did not guve much info,
Change the "TakeFocusOnClick" property to false for all command buttons.
Please indicate you OS and Office version next time.
Some more code would also help.
Regards,
Jean-Yves
 
I think i found the problem, i talk to the It-people and they said that
there was a problem with the network! I hope they solv it tomorrow!
 
You must log in or register to reply here.

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

Similar Threads

Button looses Macro setting when running Macro 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
automation error when closing excel 3
Closing Workbook then Activating Other Wb with Userform showing? 1
2003 created Workbook casuses error when macro runs in 2007 2
How to identify Chart Source data as range? 3
Simple VBA Code written in Excel 2003 not working in Excel 2000 4
Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is p 5

Back
Top