I am writing a tool for a client using Excel 2016. One part of the tool unhides a number of rows depending on the number of lines the user needs for data entry (based on a number they enter into a cell; they then click a button to unhide the rows).
The first data entry cell in the first of these rows is then selected from within the VBA. This works perfectly on my laptop and on some PC's. However, on some user's PC's, although the selected entry cell is not locked (my code never locks/unlocks these cells) the user cannot type into it... or rather they can type into it but nothing appears in the cell! Sometimes they can type into the formula bar instead of directly into the cell and other times pressing F4 twice seems to clear it.
I have tried putting an Application.Wait into my code to see if slowing it down by a second makes any difference, but this doesn't seem to help.
Does anyone have any thoughts on what might be causing this; it seems totally bizarre to me and I'm pretty sure that there is nothing in my code which is causing the problem.