saving option
Alex,
You are welcome.
Sounds like quite a team, I don't know why and you don't know what.<g
The code finds the Close button on the File menu and tells it to run the command.
Jim Cone
"Alex"
wrote in message
...
Thank you very much, Jim.
I don't know what this code means but it has resolved all issues.
"Jim Cone" wrote:
Alex,
You got me stumped.
When the button is clicked, the "ThisWorkbook.Save" code line does not execute.
The only thing I can come up with is a 'crutch' that works, but I don't know why.
Replace the code for the button...
from...
ThisWorkbook.Close
to.......
Application.CommandBars(1).FindControl(ID:=30002). Controls("&Close").Execute
Regards,
Jim Cone
San Francisco, USA
|