I am acessing Excel VBA projects from VB6. When i open the excel document prior to looking at the prokect , how do i prevent any macros running. At present the auto open and auto close macros keep running. How can i prevent this??
Printable View
I am acessing Excel VBA projects from VB6. When i open the excel document prior to looking at the prokect , how do i prevent any macros running. At present the auto open and auto close macros keep running. How can i prevent this??
If you open the Worksheet with .Activate, try .Select instead.