no macro warning! - Page 3
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: no macro warning!

  1. #21
    Board Regular
    Join Date
    Jul 2003
    Location
    San Francisco
    Posts
    112
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I used the 2000 code on XP and changed:
    RegSetValueEx lRet, csValue, 0, REG_HEX, lSecurityLevel, 1

    We are in secured intranet and no need to worry about viruses. I need warning not to show for our group worksheet but it still does.

    thanks,
    help if you can. thanks again,m

  2. #22
    Board Regular zilpher's Avatar
    Join Date
    Mar 2003
    Location
    Swindon, UK
    Posts
    442
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I can't believe this code has been posted here, talk about opening the door.

    It's not suitable for your needs anyway, you want the user to open your workbook and get no warning about the macro that is about to run; I'll bet you have used this code in your workbook, as a macro, which means Excel will see it and display the warning before it runs it. Open your workbook, let the code run then check your macro security level.

    To use this code you need another mechanism for running it other than excel, and you need to instruct your users to use that mechanism to open your spreadsheet. (I am not going to tell you how to do that in an open discussion).

    This opens you up to all sorts of risks, even if you are on a secured intranet you need to worry about viruses; users bring them in from home on floppies, usb pens, CD's, emails etc.

    And of course, all the l337 h4cx0r5 now know how to get round the macro warning because this thread will appear in google soon enough.
    Z
    ______________________________________________________________________
    Windows 7 Ultimate (x64), Office Professional Plus 2010
    Mac OS X 10.6.4, Office 2008 Mac
    Windows XP Pro, Office 2003
    Debian 5.0 (Lenny), OpenOffice

  3. #23
    Board Regular
    Join Date
    Jul 2003
    Location
    San Francisco
    Posts
    112
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: no macro warning!

      
    Ok thanks though. I did try to use it but it did not do anything. I know the risk involved and you are right, we use our app from VPN. Its just users often click "disable" the macro when they open the application and wonder why the automation does not work. Its happens almost everyday.

    This is the only way to by pass this at least for a particular excel workbook application.

    thnks,

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com