gary_wood_1999
New member
Hello
We have fairly recently upgraded to Office 2013. One particular excel workbook we use has 60 plus worksheets and therefore we use a simple VBA popup menu created by clicking on buttons at the top of each sheet to ease navigation rather than scrolling through all the Sheet Tabs at the bottom of the workbook.
This macro has always worked fine on our older versions of Excel. In Excel 2013, while the macro still executes and takes you to the desired page, after running the macro you can no longer close the workbook by going up to the top right corner and clicking the X. In addition you cannot scroll down the sheet using the wheel on the mouse (although you can by dragging the scroll bar down on the right hand side
If you do not use the macro, and manually click on the Sheet Tabs, everything works fine. Similarly if you run the Macro ("CreateDisplayPopUpMenuCourse" in the attached example file) from the developer tab rather than clicking on the button, it works without an issue. I found a post regarding a similar issue which said it was something to do with userforms being Modal or Modeless but I haven't being able to find a solution to this.
I have created a very simple example to demonstrate the issue. Please note that the problem only exists in Excel 2013.
If anyone has any solutions to this problem I would be very grateful.
Many thanks,
Gary
We have fairly recently upgraded to Office 2013. One particular excel workbook we use has 60 plus worksheets and therefore we use a simple VBA popup menu created by clicking on buttons at the top of each sheet to ease navigation rather than scrolling through all the Sheet Tabs at the bottom of the workbook.
This macro has always worked fine on our older versions of Excel. In Excel 2013, while the macro still executes and takes you to the desired page, after running the macro you can no longer close the workbook by going up to the top right corner and clicking the X. In addition you cannot scroll down the sheet using the wheel on the mouse (although you can by dragging the scroll bar down on the right hand side
If you do not use the macro, and manually click on the Sheet Tabs, everything works fine. Similarly if you run the Macro ("CreateDisplayPopUpMenuCourse" in the attached example file) from the developer tab rather than clicking on the button, it works without an issue. I found a post regarding a similar issue which said it was something to do with userforms being Modal or Modeless but I haven't being able to find a solution to this.
I have created a very simple example to demonstrate the issue. Please note that the problem only exists in Excel 2013.
If anyone has any solutions to this problem I would be very grateful.
Many thanks,
Gary