Question on command buttons

[khushbu.bhandari]

Hi,

I have one workbook which is a master copy and another workbook in which i need to automatically update the values that are in workbook 1.

I used Edit> Links> Update to do this everyday. Is there a possiblity that i can use a command button to do this?

There are no macros written for this.

Thanks

 

[Simon Lloyd]

you dont even need to click a button, add this to the thisworkbook code module

Private Sub Workbook_Open()
Me.UpdateLinks = xlUpdateLinksAlways
End Sub

How to Save a Workbook Event Macro
1. Copy the macro above by highlighting it then Right Click selected code and Copy.
2. Open your Workbook and Right Click on any Worksheet's Name Tab
3. Left Click on View Code in the pop up menu.
4. Press ALT+F11 keys to open the Visual Basic Editor.
5. Press CTRL+R keys to shift the focus to the Project Explorer Window
6. Press the Down Arrow Key until ThisWorkbook is highlighted in blue.
7. Press the Enter key to move the cursor to the Code Window
8. Paste the macro code using CTRL+V
9. Save the macro in your Workbook using CTRL+S

 

[khushbu.bhandari]

Thanks you. I shall try this and get back.

But in case i want to creat a command button. what code should i write for this?

 

[Simon Lloyd]

use this:

ThisWorkbook.UpdateLinks = xlUpdateLinksUserSetting