Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Publisher / Programming / October 2005

Tip: Looking for answers? Try searching our database.

Three questions :-)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gone Fishin - 12 Oct 2005 11:18 GMT
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 - 12 Oct 2005 12:43 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
> 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...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.