Office 365 Main sheet data overlap other sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1657696%22%20slang%3D%22en-US%22%3EOffice%20365%20Main%20sheet%20data%20overlap%20other%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1657696%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20VBA%20enabled%20programing%20sheets%20in%20Excel.%20Since%20last%201%20week%20facing%20problem%20that%20while%20opening%20another%20sheets%20(having%20control%20button%20of%20sheet%20on%20main%20sheet)%20the%20data%20of%20the%20main%20sheets%20even%20overlap%20on%20the%20other%20sheet%20that%20I%20open%20to%20work.%20Even%20when%20I%20save%20data%20through%20macro%20enabled%20VBA%20command%20button%20the%20other%20buttons%20disappear%20on%20the%20sheet.%20So%20I%20have%20to%20manually%20return%20to%20the%20main%20sheet%20through%20bottom%20tab%20click%20and%20than%20again%20have%20to%20return%20back%20on%20the%20working%20sheet%20(Where%20I%20have%20clicked%20the%20command%20button%20to%20save%20the%20data).%20Doing%20so%20the%20button%20and%20other%20formats%20of%20the%20sheet%20displays%20fine.%20But%20as%20I%20go%20to%20record%20more%20data%20in%20the%20same%20sheet%20the%20same%20problem%20as%20stated%20above%20started%20to%20happen%20and%20I%20have%20to%20do%20the%20same%20process%20to%20go%20back%20on%20main%20sheet%20and%20return%20to%20that%20sheet%20to%20complete%20work.%20Any%20solution%20for%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1657696%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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?

0 Replies