VB Buttons not working

  • Thread starter Thread starter Davis
  • Start date Start date
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!
 
I would look at the underlying code to see if the partition and the folder
match the code.
c:\myfolder\myfile.xls
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top