commandbutton code

[jeff]

any can give me codes for the commandbutton .... i ahve simple form then i
put two command button ( commandbutton1 for save and commandbtton2 is for
exit) what i want is if i click the save it save all the changes made inside
of the workbook and if I click the exit it will close the workbook.

thanks a lot .....

 

[Frank Kabel]

Hi
for saving
activeworkbook.save

for closing
activeworkbook.close