no macro warning!
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: no macro warning!

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi
    How do you stop the macro warning msgbox showing everytime Im about open a workbook containing macros?

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Go to TOOLS > MACRO > SECURITY. You can change the setting there.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    97
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was browsing and this topic caught my eye. I realize that to be a solution, however, what if I don't want to change a users setting so that it won't prompt all of the time. I want it to not prompt only for my app. Any ideas?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thats what I would think too! Idont want to sacrfice every program, just this one!!

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Don't forget, the whole point of a macro warning is so someone is warned of the possibility the macro contains a virus. If someone wishes to be forewarned of a spreadsheet that has a macro, do you really think you should be trying to get around it?

  6. #6
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-12 12:56, tk19 wrote:
    Don't forget, the whole point of a macro warning is so someone is warned of the possibility the macro contains a virus. If someone wishes to be forewarned of a spreadsheet that has a macro, do you really think you should be trying to get around it?
    It depends. Yes, it is a good idea to leave it alone, especially if you're downloading stuff.

    However, if you wrote the macro yourself and/or you are the only person who uses the workbook (which is the scenario for me), then it can become very tiring to see it every single time.

    _________________
    "What am I, a magnet for these idiots?"
    --Pearl Forrester, MST3K

    [ This Message was edited by: Von Pookie on 2002-03-12 13:01 ]

  7. #7
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you are using Excel 97, you can password protect the workbook (when saving), and it won't ask to enable macros when opened. It will, however, ask for a password.

    I don't think the case is the same in XL 2K.

    -rh

  8. #8
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In XL 2000 you can add a digital signature. I've never used this so you'll need to look at Help for more on this, but basically the digital signature tells XL that the file is from a trusted source and not some pre-pubescent pleb that copied some malicious code from the internet.

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, you beat me to it mark, You have to install the digital signatures from the office disk (features/office tools/digital signture for vba, click arrow/run my comp)


    Then find the file c:/program files/microsoft office/office and click on self cert.exe and list your name

    Then go to v.b. and click on the workbook your using and choose tools/digital signatures/choose/ok/ok.

    Last close program (save it), reopen it and it will promp you one last time, check off the checkbox and your all set!!!

  10. #10
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Is it me, or is that scary? How does this prevent "some pre-pubescent pleb that copied some malicious code from the internet" (Mark O'Brien's words, not mine) from creating his/her own signature?

    Maybe it stores some of your computer's info? Todd, did you have to register anything online or anything like that?

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