Hi

I am a beginner in VB or Excel. I am doing some data entry stuff in my company.

here is my problem:

I have 2 work sheets in the workbook. my code changes the 1st sheet and adds new information to the 2nd sheet. I want to close the workbook without saving the sheet1 (I want to save the sheet2).

I used this code: activeworkbook.close savechanges:=false but this applies to whole workbook.

Can anyone help me in solving this problem?