Forum Discussion
automatically updating other sheets when data entered based on certain data entered
You could also assign a key combination like Ctrl-U to the macro. Then you don't need a button. But something need to trigger the execution of the macro.
Riny_van_Eekelen This is JUST ABOUT perfect. Is there anyway it will update automatically? Without hitting the update Code Button?
You could also assign a key combination like Ctrl-U to the macro. Then you don't need a button. But something need to trigger the execution of the macro.
Well, you can certainly open a macro enabled workbook (.xlsm) using VBA. But, as far as I know, it does require user confirmation to either enable or disable the macro(s).
Would it be an option to have the .xlsm file open to begin with and from there, have a macro pick-up your data from other file(s) and dump it into the "SharePoint" sheet, rather than having the other program/file push data into the .xlsm file?
- I was trying to get Flow to update the workbook (as you seen SharePoint sheet), but Flow doesn't do that yet. Is there a way to have an excel spreadsheet update a macro enabled workbook (automatically)?