Three questions :-)

[Gone Fishin]

Hello everybody, I hope you can help

I have a dialog box (user form) triggered when my publication opens. On it
are a couple of buttons (one "Start" which calls a sub named "Portrait", the
other "cancel" which hides the dialog and exits)

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?

secondly, I have used application.screenupdating=false to try and stop
'flickering' as the macro is running, but this seems to have no effect. If I
did get this to function, is there a way to communicate with the user to
show progress (eg status bar or similar).

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?

Thanks very much

 

[Ed Bennett]

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.

 

[Gone Fishin]

Is your code signed or unsigned? What is your macro security level?


I can't say I've ever used this option.


You could add a progress bar or label on your UserForm.


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...