Results 1 to 3 of 3
  1. #1
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480

    Is there a way to determine if the user is opening the VBE? Like a VBE onload event?

    Hello again,



    Does the Visual Basic Editor have its own on load event? I'm coding in VBA but not using access . So I don't have the ability to make an mde or password protect the code. I've tried searching google but I'm not coming up with anything useful. Anyone have any thoughts?

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Not sure what you're after. For me, the title suggests you want to know if anyone is attempting to view code, which I suppose you could trap with key press events. However, the post body doesn't support that assumption for me.
    You're coding in another MS Office program and need to password protect the code? AFAIK, any of those have that capability.
    You're coding in the editor for one of those programs, or just using a text editor and want the features of the editor?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    I'm coding in a system Called Reflection, by attachmate. It's a terminal emulator that has its own visual basic editor. I'm still coding in VBA, I just have .... alot less out of the box abilities.

    I am wondering, if like a form/sheet/workbook the Visual Basic Editor has its own onload event. I know you can meta program the VBE itself, so has anyone coded the VBE to know if its loaded or visible?

    I think I found what I'm looking for.
    http://www.cpearson.com/excel/vbe.aspx
    Microsoft Visual Basic for Application Extensibility is what I needed, now I can make the VBE run code against itself in a way.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-05-2015, 09:10 AM
  2. Mousemove event determine control name
    By dcdimon in forum Programming
    Replies: 3
    Last Post: 07-01-2015, 04:26 PM
  3. Replies: 3
    Last Post: 05-14-2015, 01:07 PM
  4. Replies: 3
    Last Post: 12-22-2014, 11:57 AM
  5. Onload event doesn't work for filter
    By tagteam in forum Forms
    Replies: 2
    Last Post: 02-12-2014, 11:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums