Runtime Error 13 - UserForm

  • Thread starter Thread starter rmandle
  • Start date Start date
R

rmandle

Hello:

I am having trouble with showing a user form. I have a master file
that compiles a set of data and then is used to create 10 separate
files that need to be distgributed to team leaders. This file is
creating using another Leader Master file. VB is used to open and then
rename using the saveas command for each of the ten team leader files.
The VB program also distills the dataset so that each group leader gets
only the relevant data.

The problem is once these files are created, the Userform.Show command
no longer works and I am given a Runtime Error 13 notice. What is
strange is that it works fine in the main file.

Any ideas?

Rob
(e-mail address removed)
 
Thanks for the quick response Steve!

It is in Module one. It is simply:

Sub Show_UserForm()
MsgBox "Use the Following Form to complete the recommendation item
Worksheets. You will need to click *Next* once and then *Previous* to
begin."
UserForm2.Show
End Sub

I have a button placed on the worksheet which I click and then the user
form loads. I have also tried having the userform open automatically
upon opening. the workbook. That also does not work and gives me the
same error.

Rob
 
All, disregard my question. I figured it out. Apparently, my code
inserted a reference to the master file name in a formula format.
Since my program changes the name of the master file, the reference is
no longer valid and buggers up my macro.

Thanks for listening!!

Rob
 
Back
Top