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 / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

Opening form in VBA. No error,code just breaks.Works on other PCs!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bUncE - 27 Nov 2007 12:10 GMT
Morning all!

((Im using 2003))

I have a button which is supposed to open a userform (which performs a data
scrape after users enter login info and hit enter.. )
This has worked fine for a while but for some reason when i opened it this
morning lo and behold it doesnt work.
I guess an explanation of this error would be too much to ask from
Microsoft.  

Basically my code is this simple
************************************************************
Public Sub OpenScrapeForm()

frmScrape.Show

End Sub
************************************************************

It just breaks on the frmScrape.Show, no error or any indication as to why
it doesn't work.
Also i figured i would test it on another PC, it works fine?!

The only thing i can think of is some muppet of a Network Admin has messed
around with my Windows profile or im being a total muppet and missing
something completely obvious..

Any help is much appreciated,

Thanks

Mike
Hemant_india - 27 Nov 2007 14:49 GMT
check the security level  it might have been set high
thereby disabling macros
Signature

hemu

> Morning all!
>
[quoted text clipped - 29 lines]
>
> Mike
 
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.