Excel macro unprotect all sheets

broken image
broken image

like a OnBexRefresh-Event handler somewhere (even though I haven't seen it in the class module. To run macro as the workbook opens we will use Workbook Event Workbook_Open.I need resolve two problems in access database: 1. While I don't need to do do this, it appears by adding this in, Excel waits while the data is refreshed before continuing with the rest of my macro. Excel vba run macro after query refresh Click on Insert then Module.

broken image