Perhaps in the Workbook_BeforeClose event
If Thisworkbook.Saved=False Then ThisWorkbook.Save True

Not sure what you mean aboyt the Y/1 issue, but in the Workbook_Open you
can:
ThisWorkbook.Range("Counter").Value=ThisWorkbook.R ange("Counter").Value+1

NickHK

"divya" wrote in message
oups.com...
Is there a method by which we can programatically save the workbook?
Like workbook.close closes the workbook,I couldn't find
workbook.save.Is there a way to do.
Actually therz a variable suppose y, if its 1 then next time the user
opens the workbook therz a form which should'nt be displayed.So what I
did is copied the value of y into one of the worksheet and cheking
this cell value in the workbook_open event .if not 1 then dispalys the
form.But problem arises when user inputs Y as 1 and closes the book
without saving.The value of y is not saved in the book,so next time
form opens when he opens the workbook.
My problem can be solved either of two cases

1.therz a way to force the workbook to save immediately after taking
the input value for y,programatically.
2.A way to find that workbook is opened for the first time.

Kindly suggest a way

Regards