ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Problem (https://www.excelbanter.com/excel-programming/340259-macro-problem.html)

Marco[_8_]

Macro Problem
 
Hy,
i've made an excel file with a macro that
execute this operation:
-open a pop-up to put username and password
-check this on-line
-refresh every minute the spreadsheet with some dates from a server

Until now it's all ok,
but on a 2000 professional/Excel 2000 (9.0.2812)
the macro is not execute!
and no error is showed
where's the wrong?

the macro are available!

the firs instruciont of the macro is:

Private Sub Workbook_Open()
10 Worksheets("Dati").Range("A65535").Value = "0"
20 Worksheets("Dati").Range("B65535").Value = "::"
30 UserForm1.Show
End Sub

but the UserForm1 (the pop-up with the form)
doesn't open!

what's the problem/error?

It could be a antivirus?
(this file is on a the pc of my client!)

thank you..
ans sorry for my english!


Tom Ogilvy

Macro Problem
 
Is your user disabling macros when they open the workbook?

Do they have an addin installed that disables macros?

--
Regards,
Tom Ogilvy

"Marco" wrote in message
oups.com...
Hy,
i've made an excel file with a macro that
execute this operation:
-open a pop-up to put username and password
-check this on-line
-refresh every minute the spreadsheet with some dates from a server

Until now it's all ok,
but on a 2000 professional/Excel 2000 (9.0.2812)
the macro is not execute!
and no error is showed
where's the wrong?

the macro are available!

the firs instruciont of the macro is:

Private Sub Workbook_Open()
10 Worksheets("Dati").Range("A65535").Value = "0"
20 Worksheets("Dati").Range("B65535").Value = "::"
30 UserForm1.Show
End Sub

but the UserForm1 (the pop-up with the form)
doesn't open!

what's the problem/error?

It could be a antivirus?
(this file is on a the pc of my client!)

thank you..
ans sorry for my english!




Marco[_8_]

Macro Problem
 
Is your user disabling macros when they open the workbook?
no

Do they have an addin installed that disables macros?

i don't konw...
what could be "addin installed"?

thank!


Marco[_8_]

Macro Problem
 
Is your user disabling macros when they open the workbook?
Do they have an addin installed that disables macros?


the problem is "panda antivirus"!
my client... has call me now!

thank you!



All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com