Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel Macro workbook_open() BUG with addins?


  • Please log in to reply

#1
lang0477

lang0477

    New Member

  • Member
  • Pip
  • 1 posts
Hello guys, I really need your assistance ;)
I wrote a VBA macro do some calculations and I added a splash screen with:

Private Sub workbook_open()
UserForm2.Show
End Sub

now here is the problem, I save my macro as an addin, and enable this add-ins in excel "tool". now if I open an empty(new) excel workbook, everything includes my addin work just fine, my userform2 displays at the begining.
but if I open any existing(saved) workbook that contains data, it will behave like this:
userform2 displays as before, then it disappear as expected(After few second), but there isnt any workbook got opened, the excel window is here and it is gray, i can mannually create a new workbook or click open file button to open other workbook, but it doesnot open the workbook I chose automaticlly after i double click on the workbook icon.

I am pretty sure the problem has something to do with workbook_open sub,
if only I erase this sub, everything will be just fine.

I have searched so many online tutorials but none of them addressed the problem,
anyone knows what might be the reason?
thanks a lot :tazz:
  • 0

Advertisements


#2
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
same problem in powerpoint

i couldnt get my user form i created in excel to show up in powerpoint (VBA)

i guess it does nt like it

ill look into it further

Stu
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP