LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 100
Default Excel macro security fails in directory XLSTART.

Book1.xls contains this autoexec macro:

Sub Auto_Open()
MsgBox ("Macro Auto_Open has launched")
End Sub

My Excel 2002 (10.2614.2625) macro security is set to Medium.

No matter where Book1 resides, Excel’s Enable/Disable macro warning
dialog correctly appears whenever I open it.

*Except* in Excel’s auto-launch directory, C:\Documents and Settings
\Administrator\Application Data\Microsoft\Excel\XLSTART.

In that case, launching Excel automatically launches Book1, as it
should. But security completely fails, and the Sub wrongly launches
and the message displays.

What is wrong? Does Administrator status kill Excel macro security?

Thanks.

***
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
i created a macro in a xlstart folder.how do i do to insert in too Roughar Excel Discussion (Misc queries) 1 October 21st 09 01:48 PM
SECURITY UPDATE FAILS TO INSTALL Ameneses Excel Discussion (Misc queries) 0 December 10th 08 07:20 PM
XLStart directory woburn Excel Discussion (Misc queries) 1 February 23rd 05 09:05 PM
Creating a macro that lists directory names within a directory.... Andy Excel Programming 4 November 28th 04 06:13 AM


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"