Correct Vba By Macro

[mprice40ca]

I have a huge quantity of workbooks that access another workbook and use a "modular" macro to print specic pages inside a work book, check and correct some other links...

anyway the location of the workbook moved due to IT issues.

is there a way to write a macro to change the VBA from:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

So that the users can make there own corrections.

Moderator's note: Please review forum rules. Rule #3 requires CODE tags around VBA code. I have added them since it's your first post. --6SJ

[BravesPiano5]

You need to reference the excel file's full path...not the mapped drive it's located in.

[mprice40ca]

The buttons work as shown I need to learn how to delete the \New G Drive out of the upper illistration by macro.

[mprice40ca]

I don't believe there is a way to alter a macro by macro I found a couple of instances where i came close but Excel shut me down I think it is protecting itself from Virus/hackers.

Anyway i found a workaround i recreated my worksheet where the buttons attached to it pointed to the correct location then made a macro to import the sheet into the workbook and transfer any information previously contained on that sheet and then delete the old one-- worked out good Maybe better I changed a couple of colors on the sheet so it would be very visual if it needed updated.