View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default When running workbook.close True Excel generates an error!!!

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


"Daniel" wrote in message
om...
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