Microsoft Office Forums - View Single Post - Can't get Macro to work in This Workbook

Thread: Can't get Macro to work in This Workbook

View Single Post

Old

01-10-2018, 10:08 AM

Logit

Logit is offline

Logit uses Windows 10

Windows 10 Logit uses Office 2007

Logit uses Office 2007

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Logit is a jewel in the rough

Default

Place your entire macro into a Routine Module (not in ThisWorkbook).

In ThisWorkbook paste this :

Code:

Option Explicit

Private Sub Workbook_Open()
    uploadmaster
End Sub

That will run the macro each time the workbook is opened.

Reply With Quote