Posted to microsoft.public.excel.programming

Karl Steinam Karl Steinam is offline

external usenet poster

Posts: 2

How to disable autoopen() programmatically

Ron de Bruin wrote:

Hi Karl

Sub Auto_open()
MsgBox "Hi"
End Sub

Must be in a normal module
If you use a Auto_open macro then this wil not run if you open the file with a macro

Thanks for the quick answer

KS

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Disable macros on a programmatically opening .xls file	Matt[_2_]	Excel Discussion (Misc queries)	2	May 25th 07 04:45 AM
Does anyone know how to programmatically disable Application.xlcut	Fonda	Excel Programming	1	June 30th 04 01:58 AM
'Yes' 'No' button on autoopen macro	Larry	Excel Programming	2	May 21st 04 09:59 PM
Disable AutoOpen macro's	Michael Beckinsale	Excel Programming	1	October 16th 03 01:48 PM
Can i set a reference programmatically?	Tom Ogilvy	Excel Programming	1	August 19th 03 04:24 PM

All times are GMT +1. The time now is 02:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us