VB Buttons not working

D

Davis

On pc "A", I have 3 workbooks. The workbooks are linked
together with VB buttons. Very simple - click the button
on one workbook and it takes you to another workbook.
Everything works well.

I copied these 3 workbooks over to pc "B" so that I can do
some editing on the workbooks. PC "B" appears to be set
up the same as "A". However, the VB bottons do not work.
When I click on a button, I get an error that
says "subscript out of range".

Does anyone have an idea on what is happening with the
copied workbook's VB buttons not functioning?

Thanks in advance for your help!
 
D

Don Guillett

I would look at the underlying code to see if the partition and the folder
match the code.
c:\myfolder\myfile.xls
 
D

DavidP

At a guess the macros file references include the complete Path statement e.g. c:\Microsoft\Excel\MyFile.txt".
I suspect fthe folder structures are different on PC "B". Simply finfd the corect path and amend the macros to compensate

DavidP
 
Top