Excel Macro/Code not working on Surface Pro

Question

Hoping someone can help!

I have a programmer who's been working with me to setup an Excel template for a client which allows them to record details for a report.

Basically, once they open the Excel template they see a list of various criteria. Once they double click on the criteria, this takes them to a page (which is visibly hidden and so can only be accessed by double clicking) whereby they can fill in the appropriate criteria ratings. To fill in the criteria ratings they double click on the cell and a dialog box appears with the list of criteria for them to choose from.

They continue with this on the page until finished. We have created a new tab on the Ribbon which gives them access to go back to the initial screen whereby they can double click on a new criteria and complete the details accordingly.

We have set this up to be compatible with Excel 2010 upwards. I have tested it on 2010, 2013 and 2016 and all works fine.

The problem is when testing it on a Surface Pro (which my client will be using). As they are often wandering around their client site, they are using the Surface Pro as a tablet - so they don't have a mouse to double click. 

Unfortunately, when they double tap the screen, it tells them it is locked and they can't proceed.

We tried changing the code to accept a right click instead. Once again, this works great with a mouse but not by tap and hold (right click option on touch screen). It actually shows the right click shortcut menu (so that part is working) but it won't run the code to take them to the corresponding page.

We've tried to find the answer but I thought I would put this to the community.

Hope someone can help!

Thanks,

Nicole

Answer 1

Thank you for responding. I appreciate it.

I had a look at the settings and unfortunately, there is nothing in here that will particularly help but worth a look.

My Surface Pro works well normally with double clicking/tapping or using pen. The problem is specifically with how it integrates with VBA code and events within. 

I've only managed to find one other person with this same issue, however, no one has responded to their query. 

If I use a mouse, the VBA code works perfectly - it's the touch screen which stuffs it up. There must be a solution!

Thanks,

Nicole

Answer 2

My Surface Pro works well when double clicking with the pen but only some of the time with touch screen. I think that it depends if it is touched exactly in the correct place.

Following added after initial posting.

If you select Start -> Settings and enter touch in the "Find a setting" field you will see a stack of settings that you might like to view and see if you can find a setting to improve the touch double click.