Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an object-heavy spreadsheet with alot of code supporting those objects on a single sheet module. For some reason when on of the routines is executed, it jumps to the first routine in the module, runs it and then returns back to continue the first. The point at which it jumps is shown below. The sub it jumps to is "
' Save the request with a new name. ActiveWorkbook.SaveAs Filename:= _ "C:\temp\PTR" & piRequestNo & ".xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False 'The jump occurs here. ActiveWorkbook.SendMail , Subject:="Pass Thru Request", ReturnReceipt:=True Jumps to here Private Sub cbCat1_Change() Is it possible to have too much code on a sheet module? I'm thinking I need to move some of this code to a separate, non-sheet module. Any help would be tremendously appreciated. Ross |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Private Sub() - Sub() | Excel Discussion (Misc queries) | |||
Private sub | New Users to Excel | |||
Private Sub | Excel Programming | |||
Private Sub Workbook_Open() not running on open | Excel Programming | |||
Problem with private sub | Excel Programming |