On 26 Nov, 22:14, JacquieAtFRCC
wrote:
I have written macros and tested them in VBA. They do run. I have assigned
these macros to buttons on a report worksheet. I have changed Excel security
settings to allow all macros and allowed access to the VBA project module.
However, when I click on the buttons to run the assigned macro, the macro may
function one time and not the next. It seems that if I reset the Security
settings each time before I run a macro, the macro seems to run, but this
isn't an acceceptable fix. Does anyone know why the macros function
sporadically?

Hi,

Have you got an example of a macro that has this behaviour, might be
worth ruling out your code in the first instance.

James