LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel default module when opening visual basic editor


Why does the visual basic editor open to a module that is not my most recent
runned module. It is not even one is alphabetically on top of the list. Is
the default the last "built" module name?

It seems to open to the last module that was run, that has a call stmt in a
separate call sub , above that sub. And also that module's run was logged,
and the log was dumped into a worksheet.

When I run a module called "exp", and save excel, then reopen and click
visual basic editor it keeps going back to some other module (as I stated the
details above)

Sub CallFix()
For ii = 1 To 24
Call FixSpd("Vn")
Call FixSpd("PUB")
Next ii
End
End Sub
Sub FixSpd(fx$)
Dim test As Boolean, outs As Object, inps As Object
Dim r$(20), bn$(5)
.....
......
end sub

this module is where vb editor opens too, not my last run module which has
no "call module" over the main code.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening Visual Basic Editor SteveG[_5_] Excel Discussion (Misc queries) 0 March 19th 09 01:46 PM
please help : Excel visual basic editor AMIT Excel Programming 2 March 16th 07 08:01 PM
Can I run Visual Basic procedure using Excel Visual Basic editor? john.jacobs71[_2_] Excel Programming 3 December 26th 05 02:22 PM
How to disable Visual Basic Editor in Excel file No Name Excel Programming 2 April 24th 04 01:52 PM
Visual Basic editor terminates Excel 2003 Jim Zeeb Excel Programming 3 January 30th 04 08:22 PM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"