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


"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

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!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!