I am using VBA enabled programing sheets in Excel. Since last 1 week facing problem that while opening another sheets (having control button of sheet on main sheet) the data of the main sheets even overlap on the other sheet that I open to work. Even when I save data through macro enabled VBA command button the other buttons disappear on the sheet. So I have to manually return to the main sheet through bottom tab click and than again have to return back on the working sheet (Where I have clicked the command button to save the data). Doing so the button and other formats of the sheet displays fine. But as I go to record more data in the same sheet the same problem as stated above started to happen and I have to do the same process to go back on main sheet and return to that sheet to complete work. Any solution for this problem?