does anyone know how to make a macro work on a protected workbook.
see the attached file as an example. It is protected. On sheet "GLC Trend View" the listbox is populated via macro. when the workbook is protected, it is saying my security level is too high. I have enabled all macros so this is not the case. the password to open the workbook is "ops" so you can play around with it.
I need a workaround so the file can be protected but the macro work.
Thank you for your help
https://www.dropbox.com/s/i3txahepv6q62sk/GLC Patient Flow Report- MTD (2).zip?dl=0
see the attached file as an example. It is protected. On sheet "GLC Trend View" the listbox is populated via macro. when the workbook is protected, it is saying my security level is too high. I have enabled all macros so this is not the case. the password to open the workbook is "ops" so you can play around with it.
I need a workaround so the file can be protected but the macro work.
Thank you for your help
https://www.dropbox.com/s/i3txahepv6q62sk/GLC Patient Flow Report- MTD (2).zip?dl=0
