Activation of sheet and editing sheet no longer working in excel2013, but worked

Question

Activation of sheet and editing sheet no longer working in excel2013, but worked in previous versions

I use a userform in main workbook. With a cmd button I select and open new workbook (can be 20different ones). Ones opened I need to fill in quanties in the opened workbook (= a checklist) and ones completed I copy them in the first book. This worked fine till excel 2013. With 2013 the workbook opens and is displayed, the correct cell is selected, but when I fill in a value = number and press any key, the value which is first filled in into the correct cell is automatically transferred to the first workbook (same cell, but wrong workbook and sheet)

When I than manually switch between the two workbooks it works fine.

The activation of the new workbook seems not to work identical like in 2010 and I really have no clue how to solve this. Spend already days online, but no similar issue found.

It 's really important to make this working, as I made a complete package for my company to be used by more than 50 peoples on excel 2013 and 2010.

Moreover, I'm working now on the new surface Pro 3 and if I can lounge this correctly it would be an investment to get them all working on the new surfaces... but first it needs to work ofcourse.

So, the code is more or less working, the workbook is activated and shown, but not 'behaving' as the activated one.

the code I use to activate the other workbook: (tried already lots of different solutions, but same end result)

Workbooks(MachineInspectieLijst & ".xlsm").Activate
Workbooks(MachineInspectieLijst & ".xlsm").Worksheets(MachineInspectieLijst).Activate
Workbooks(MachineInspectieLijst & ".xlsm").Worksheets(MachineInspectieLijst).Visible
Workbooks(MachineInspectieLijst & ".xlsm").Worksheets(MachineInspectieLijst).Range("V5").Select

How should I activate workbook and sheet to be able to manually fill in data in the new opened workbook and with cmd button copy the data to the original workbook. All the commands in the original workbook are done by means of a userform.

additional info: when the new workbook is opened and sheet displayed, you notice that you can not save the workbook, only when switching between the workbooks it becomes possible to save.

hope somebody can help!

Explanation / Answer

One problem that I see in your code is highlighted in bold:

Before:

Workbooks(MachineInspectieLijst & ".xlsm").Activate
Workbooks(MachineInspectieLijst & ".xlsm").Worksheets(MachineInspectieLijst).Activate
Workbooks(MachineInspectieLijst & ".xlsm").Worksheets(MachineInspectieLijst).Visible
Workbooks(MachineInspectieLijst & ".xlsm").Worksheets(MachineInspectieLijst).Range("V5").Select

After:

Workbooks(MachineInspectieLijst & ".xlsm").Activate
Workbooks(MachineInspectieLijst & ".xlsm").Worksheets(MachineInspectieLijst).Activate
Workbooks(MachineInspectieLijst & ".xlsm").Worksheets(MachineInspectieLijst).Visible = True
Workbooks(MachineInspectieLijst & ".xlsm").Worksheets(MachineInspectieLijst).Range("V5").Select

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.