Can't get Macro to work in This Workbook

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Can't get Macro to work in This Workbook

01-10-2018, 10:08 AM

Logit

Windows 10 Can't get Macro to work in This Workbook

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
One macro to sort individual sheets in a workbook	darbybrown	Excel Programming	1	09-11-2016 12:51 PM
Spell check macro within macro button field doesn't work in one document	samuelle	Word VBA	0	07-20-2016 02:27 AM
Personal Macro Workbook Does Not Load	WRowan	Excel	1	06-23-2016 08:26 AM
How do I assign a macro to a button when the macro is in my personal workbook?	foolios	Excel Programming	2	07-27-2011 02:41 PM
macro to transfer data from one workbook to another workbook	virsojour	Excel Programming	5	02-01-2011 08:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:19 AM.