VBA on Excel for Mac 2011 (and is there a better to do click-generated actions?)

[Rusty315]

Hi

I'm running a simple bit of VBA code in a workbook that I created on a PC (Excel 2010) but is going to be used on a Mac (Excel 2011):

Please Login or Register  to view this content.

The macro runs perfectly and instantly on my PC but the Mac comes to an absolute standstill and freezes up completely. I haven't bothered to sit there long enough to see how long it takes (I tried it several ties and each time, I assumed the Mac completely pooped itself after the five minute mark). I did some research and found that Macs don't particularly like macros.

Is there a way to speed up the macro or make it more Mac-friendly?

If it matters, the macro is assigned to a button on a dashboard. Users select any cell within a range that contains people's names then they click the button and the value within the selected cell is copied into 'Filters'!H7'. The dashboard contains VLOOKUP formulas that look up the value in 'Filters'!H7 in a table on another sheet containing personal info. These cells will auto-populate with the information users need about that person. I could generate click-based actions with hyperlinks but the names are the results of formulas, not text typed directly into cells.

If anyone could point me in the right direction so that I can achieve the same outcome without having to use VBA or if they could help me work out a way to make the macro work faster on a Mac, I'd be extremely appreciative!

Cheers

[Izandol]

If selection is only one cell:

Please Login or Register  to view this content.