Macros function sporadically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JacquieAtFRCC - 26 Nov 2007 22:14 GMT

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?

Reply to this Message

james.billy@gmail.com - 26 Nov 2007 22:20 GMT

On 26 Nov, 22:14, JacquieAtFRCC
<JacquieAtF...@discussions.microsoft.com> 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
[quoted text clipped - 4 lines]
> 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

Reply to this Message

JacquieAtFRCC - 26 Nov 2007 22:37 GMT

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

> On 26 Nov, 22:14, JacquieAtFRCC
> <JacquieAtF...@discussions.microsoft.com> wrote:
[quoted text clipped - 13 lines]
>
> James

Reply to this Message

james.billy@gmail.com - 26 Nov 2007 22:42 GMT

On 26 Nov, 22:37, JacquieAtFRCC
<JacquieAtF...@discussions.microsoft.com> wrote:

> I will send you the workbook with the macros, buttons, etc. for your perusal.
>
[quoted text clipped - 18 lines]
>
> - Show quoted text -

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

James

Reply to this Message