Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default macro security issue

It doesn't really see them differently. You can't click on a macro that
requires an argument and hit run, which is pretty much wat the Alt+F8
approach is designed to do - so excel doesn't make them visible in the list.

--
Regards,
Tom Ogilvy

"Ladislav Ligart" wrote in message
om...
Follow up:

I found that if I removed the parameter passing, my wkbUtils.Runner
proc is called even with security on High:

fails .OnAction = "'wkbUtils.Runner " & """" & vProcs(i) & """"
& "'"
works .OnAction = "wkbUtils.Runner"

So it's the parameter that's messing things up.

Other tidbit:

With the parameter in Runner, "wkbUtils.Runner" doesn't show in
Alt+F8. But when I remove it, it does show:

no show Public Sub Runner(ProcToRun As String)
shows Public Sub Runner()

So it seems Excel views macros with parameters somehow differently.



Reply
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
Security Issue: Data Connections Disabled Katara Excel Discussion (Misc queries) 0 March 8th 07 10:59 AM
Excel 2002 Security Issue PA New Users to Excel 2 December 3rd 05 02:32 PM
Security Issue rnieland Excel Programming 2 May 27th 04 11:31 PM
Sheet construction on server security issue Jim McLeod Excel Programming 1 April 21st 04 01:41 PM
macro - security issue Mary[_6_] Excel Programming 2 October 24th 03 05:18 PM


All times are GMT +1. The time now is 07:08 PM.

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

About Us

"It's about Microsoft Excel"