I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content! For More 👉 essentialexceluk.com/blogs/tutorials
You can use the "call" function in your macro that runs on open to run any other Macro's in the workbook. Example: This runs on open and runs "reset_data" and "graph_update" macros. Private Sub workbook_open() Call reset_data Call graph_update End Sub The nice thing about this method is that you can have those macros run on open and still have them run by form or active X controls or shape buttons by the user.
I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!
For More 👉 essentialexceluk.com/blogs/tutorials
If option macros are disabled what the use of making macros then?
can i run a a code containing the last modified date of the sheet once the sheet is open? if yes how?
I try it but keep on getting the error "Sub or Function not defined"
delete option explicit
are you recording this with a calculator? i can't se anything
How do you run more than one macro automatically when document is opened? I have a number of tasks I want to run whenever its opened
You can use the "call" function in your macro that runs on open to run any other Macro's in the workbook. Example: This runs on open and runs "reset_data" and "graph_update" macros.
Private Sub workbook_open()
Call reset_data
Call graph_update
End Sub
The nice thing about this method is that you can have those macros run on open and still have them run by form or active X controls or shape buttons by the user.
I have if command. Its not automatically running. I want it to run automatically
It doesn't work for me xd
This method can be used for injecting malicious software 😄