Hide steps in running Macro?

[Hey Lucy]

I searched the forum and didn't see the answer to this. I am running a make-table macro. As is usual, the macro will ask the user to respond to certain things -- @ to run, existing table will be deleted, x number of rows will be pasted.

Is there any way (without VB) to set the macro up to run without the user having to respond and "ok" these things? There is no reason at all for the user to see this stuff running and have to respond to each dialog box.

I'm guessing that prob the only way I can do this is using VB, which I don't know, but if that's the case and someone would be so kind as to give me the code and tell me where to put it, I could handle that much .

Thanks in advanced for any help or suggestions.

 

[Isskint]

If you are doing this in a macro, use the SetWarnings action = False. Remember to include SetWarnings = True at the end AND ensure you have an error trapping step to divert the macro to SetWarnings = True or you could end up with SetWarnings = False after completion and therefore get NO warnings on anything you do.

 

[Hey Lucy]

Thanks so much! It worked!