Pat Victor
New Member
- Joined
- Jun 24, 2013
- Messages
- 2
I have a set of VBA macros used to book gigs for bands. The operator opens a venue database spreadsheet, clicks on the row for the desired venue, then clicks on an Add Gig button. The macro then creates a booking form spreadsheet, activates it and then exits leaving the booking form active for the operator to continue working on it.
This works perfectly on the PC, however recently I had to transfer the code to a Mac running Excel Mac 2011. Here what happens on exit from the macro is weird.
The visible spreadsheet is the venue database, not the booking form. The standard and formatting toolbars are greyed out. In the Window menu the venue database has the tick for the active window. The booking form I want is in the list but clicking on it produces no effect.
At this point I can activate the booking form in two ways. I can select another window in the list first; this works, then I can choose the booking form and it activates. Or, I can click anywhere in the venue database window (either on a cell or on the ribbon). The greying out disappears and selecting the booking form in the Window menu now works.
It reminded me of an early VB problem with buttons where you had to get the focus off the button before stuff would work, so I tried it as a menu command rather than a button – no difference. The code is not in This Workbook, where I know you can’t activate another workbook. I tried to mimic solution 2 above in the code by activating the venue database and selecting a cell before activating the booking form – didn’t work. I tried fiddling around directly with windows rather than workbooks, no difference. I thought it looked as if the macro hadn’t quite exited properly, a bit like needing to use Reset when debugging, so I tried using Stop, and End, neither worked.
By the way, this is not a general problem with activation – the macro activates several workbooks in the course of its processing and this works fine.
This is going to drive my PC operators mad, so please, any help would be gratefully received as after several days I am at my wits end……
This works perfectly on the PC, however recently I had to transfer the code to a Mac running Excel Mac 2011. Here what happens on exit from the macro is weird.
The visible spreadsheet is the venue database, not the booking form. The standard and formatting toolbars are greyed out. In the Window menu the venue database has the tick for the active window. The booking form I want is in the list but clicking on it produces no effect.
At this point I can activate the booking form in two ways. I can select another window in the list first; this works, then I can choose the booking form and it activates. Or, I can click anywhere in the venue database window (either on a cell or on the ribbon). The greying out disappears and selecting the booking form in the Window menu now works.
It reminded me of an early VB problem with buttons where you had to get the focus off the button before stuff would work, so I tried it as a menu command rather than a button – no difference. The code is not in This Workbook, where I know you can’t activate another workbook. I tried to mimic solution 2 above in the code by activating the venue database and selecting a cell before activating the booking form – didn’t work. I tried fiddling around directly with windows rather than workbooks, no difference. I thought it looked as if the macro hadn’t quite exited properly, a bit like needing to use Reset when debugging, so I tried using Stop, and End, neither worked.
By the way, this is not a general problem with activation – the macro activates several workbooks in the course of its processing and this works fine.
This is going to drive my PC operators mad, so please, any help would be gratefully received as after several days I am at my wits end……
