How to edit this Macro?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yhoy - 02 Dec 2007 22:03 GMT

I have a survey which is done in Excel using Macro, it can get input from
maximum 20 participants. How was the constraint put in place and how can I
release it?

Reply to this Message

Gord Dibben - 02 Dec 2007 22:11 GMT

Which macro would that be?

Gord Dibben MS Excel MVP

>I have a survey which is done in Excel using Macro, it can get input from
>maximum 20 participants. How was the constraint put in place and how can I
>release it?

Reply to this Message

yhoy - 02 Dec 2007 22:37 GMT

That is kind of my question too. It is done by a guy who already left. Is
there any way to set up the limit in macro?

> Which macro would that be?
>
[quoted text clipped - 3 lines]
> >maximum 20 participants. How was the constraint put in place and how can I
> >release it?

Reply to this Message

Gord Dibben - 02 Dec 2007 23:21 GMT

My original response was meant to elicit the macro code from you so's we could
see what to adjust.

With your workbook open go to Tools>Macro>Macros.

Select the macro by name and "Edit"

Copy the lines of code and post it.

Gord

>That is kind of my question too. It is done by a guy who already left. Is
>there any way to set up the limit in macro?
[quoted text clipped - 6 lines]
>> >maximum 20 participants. How was the constraint put in place and how can I
>> >release it?

Reply to this Message