> All is well and it works perfectly. But if I try to run the macro
> using tools/run macro, the dialog appears but the buttons do not
> function?
Is your code signed or unsigned? What is your macro security level?
> secondly, I have used application.screenupdating=false to try and stop
> 'flickering' as the macro is running, but this seems to have no
> effect.
I can't say I've ever used this option.
> If I did get this to function, is there a way to communicate
> with the user to show progress (eg status bar or similar).
You could add a progress bar or label on your UserForm.
> Finally is there a way to place a button (non printing) on my
> publication to run the macro, or do I have to include it on a
> menu/toolbar?
No, it would have to be on a menu/toolbar.

Signature
Ed Bennett - MVP Microsoft Publisher
Gone Fishin - 12 Oct 2005 13:31 GMT
>> All is well and it works perfectly. But if I try to run the macro
>> using tools/run macro, the dialog appears but the buttons do not
[quoted text clipped - 18 lines]
>
> No, it would have to be on a menu/toolbar.
Is your code signed or unsigned? What is your macro security level?
The code is unsigned. At the moment the security setting is set to Low.
> You could add a progress bar or label on your UserForm.
Thanks - I have googled and found some example code for this :-)
Thanks for the pointers...