|
-
May 13th, 2003, 06:12 AM
#3
Thread Starter
New Member
code as suggested
this is the code o n the button
Private Sub CommandButton2_Click()
Application.ScreenUpdating = False
Sheets("Dialog1").Select
DialogSheets("Dialog1").Show
Application.ScreenUpdating = True
End Sub
this is the error i keep getting
'system bid template kim29may.xls' could not be found. check the spelling of the file name, and verify that the file location is correct.
Then I get a run time error .1004, show method of dialog sheet class failed. Then I can end or bedug, if I debug this line is highlighted: DialogSheets("Dialog1").Show
All I know is the my "smart" boss combined what I was working on and what he was doing and then deleted my old file, cuz when you pushed the button in the new file it opened the old file to run the dialog box.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|