Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to edit this Macro?
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? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to edit this Macro?
Which macro would that be?
Gord Dibben MS Excel MVP On Sun, 2 Dec 2007 14:03:02 -0800, yhoy wrote: 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? |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to edit this Macro?
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? "Gord Dibben" wrote: Which macro would that be? Gord Dibben MS Excel MVP On Sun, 2 Dec 2007 14:03:02 -0800, yhoy wrote: 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? |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to edit this Macro?
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 ToolsMacroMacros. Select the macro by name and "Edit" Copy the lines of code and post it. Gord On Sun, 2 Dec 2007 14:37:00 -0800, yhoy wrote: 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? "Gord Dibben" wrote: Which macro would that be? Gord Dibben MS Excel MVP On Sun, 2 Dec 2007 14:03:02 -0800, yhoy wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can macro edit text? | Excel Worksheet Functions | |||
I know you can't run a macro while in edit mode, but... | Excel Discussion (Misc queries) | |||
How do I edit this macro? | Excel Discussion (Misc queries) | |||
Edit Macro 1st time use | Excel Discussion (Misc queries) | |||
Macro to edit formula | Excel Discussion (Misc queries) |