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?

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

I will send you the workbook with the macros, buttons, etc. for your perusal.
" wrote:

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

On 26 Nov, 22:37, JacquieAtFRCC
wrote:
I will send you the workbook with the macros, buttons, etc. for your perusal.



" wrote:
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- Hide quoted text -

- Show quoted text -

Ok I will take a look, see if I get the same behaviour.

James