We currently have a spreadsheet that pulls information out of the cells of
other worksheets. VBA was not used to build this spreadsheet and the creator
has long since left the company.
The spreadsheet broke and we can't figure out how to fix it, so I would like
to rebuild it using VBA.
I'm a little rusty and was wondering if someone could walk me through this
or point me to a HOW TO.
Thanks!

You pobably have a corrupted workbook. The way I fixed bad workbooks is copy
each sheet of the workbook to a new workbook.

1) OPen new workbook and old workbook
2) right click on tabs on botttom of old workbbok (normally sheet 1) and
click move or copy. Then copy to new workbook.

"HeatherLou1974" wrote:

> We currently have a spreadsheet that pulls information out of the cells of
> other worksheets. VBA was not used to build this spreadsheet and the creator
> has long since left the company.
> The spreadsheet broke and we can't figure out how to fix it, so I would like
> to rebuild it using VBA.
> I'm a little rusty and was wondering if someone could walk me through this
> or point me to a HOW TO.
> Thanks!
>

Joel-
Thanks for the tip - and I will try that in the future - but, when I right
click on the different workbook tabs, the copy option was greyed out.
I tried to actually copy the worksheet and paste it into a new workbook.
Here's what happened:
The password box came up (because all of the workbooks are password
protected) for the first two files. I entered the password and the next file
name came up. When the third one came up, it asked for the location of the
file. I pointed to the right file, but then the program was unable to find
ANY of the cells I need it to pull. I *know* that those cells are in there
so I have no idea why it is freaking out.
This is why I just want to build this thing in VBA. It's harder to break
that way.
Thanks!

"Joel" wrote:

> You pobably have a corrupted workbook. The way I fixed bad workbooks is copy
> each sheet of the workbook to a new workbook.
>
> 1) OPen new workbook and old workbook
> 2) right click on tabs on botttom of old workbbok (normally sheet 1) and
> click move or copy. Then copy to new workbook.
>
> "HeatherLou1974" wrote:
>
> > We currently have a spreadsheet that pulls information out of the cells of
> > other worksheets. VBA was not used to build this spreadsheet and the creator
> > has long since left the company.
> > The spreadsheet broke and we can't figure out how to fix it, so I would like
> > to rebuild it using VBA.
> > I'm a little rusty and was wondering if someone could walk me through this
> > or point me to a HOW TO.
> > Thanks!
> >