Excel Userform and Macros

[Clarkie001]

Hi,

I have several macros that I use a Userform to run, this works fine when using the workbook locally. The problem begins when I publish the report online for people to access through a website on our in house intranet site.

If I run the macros from the Tools>Macros menu they run fine, but trying to run them from the command buttons of my userform I get a error message.

Does anyone know why I am getting this issue? Please help.

Thanks in advance.

John

 

[xlbo]

Check the "TakeFocusOnClick" property of the commandbutton - change it to false if it is true. If it is already false, post the code and highlight the line it errors at

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244