Hi all,
I would like to finalise my financial planner. Macros implemented via Buttons are working perfectly fine. As I read in many different threads, there is a known issue with Events for the 2016 Mac version, when the code is embedded in a worksheet or in the this workbook module. (e.g. change from label = "General"to "Worksheet"leads to the error message in my screenshot.
Therefore, I tried many things but nothing happened really. After doing already some workarounds (example attached), I simply tried MsgBox or .Value = "10" e.g. but Excel never processed my implemented code.
Worked with different Subs,
like worksheet_change / activate / selection_change and so on. I tried to work with inputs from multiple threads like option explicit, deinstallation of add-ins, restart of application.
The only thing working out is the installation of a button with the piece of code which will be then properly executed. But this is inconvenient since I am changing many values quite frequently and aiming for an immediate update of my pivot charts on my Sheet #1. (Data is coming from lets say #5)
Has anyone ideas what else I could try to fix the issue, the support told me to address the topic in here.
I am super happy if someone could support and give an answer to my very first contribution in an online forum.
Cheers,
Patrick
| Arabic | Hebrew | Polish |
| Bulgarian | Hindi | Portuguese |
| Catalan | Hmong Daw | Romanian |
| Chinese Simplified | Hungarian | Russian |
| Chinese Traditional | Indonesian | Slovak |
| Czech | Italian | Slovenian |
| Danish | Japanese | Spanish |
| Dutch | Klingon | Swedish |
| English | Korean | Thai |
| Estonian | Latvian | Turkish |
| Finnish | Lithuanian | Ukrainian |
| French | Malay | Urdu |
| German | Maltese | Vietnamese |
| Greek | Norwegian | Welsh |
| Haitian Creole | Persian | TRANSLATE with COPY THE URL BELOW EMBED THE SNIPPET BELOW IN YOUR SITE Enable collaborative features and customize widget: Bing Webmaster Portal |