Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    On Open options (Excel 2003)

    I have a macro that opens several excel files, creates a new worksheet and updates it from the files opened. The 2 prompts I get when the macro opens the spreadsheets is whether I want to enable macros and if I want to update the links. I want to enable macros and say no to updating the links without the prompts. Can you tell me how to go about it? I have UpdateLinks:=0 in the open statement, but I still get prompted. <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: On Open options (Excel 2003)

    Concerning the update links...???

    About disabling the Enable Macro Dialog, see <post#=260328>post 260328</post#> and <post#=402499>post 402499</post#>
    These will give some good insight into the pro's and con's of the dialog and how to disable it! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

  4. #4
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    RE: On Open options (Excel 2003)

    Thanks guys. This board is wonderful! I not only get the answers I need, but am learning alot in the process.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: On Open options (Excel 2003)

    Strange. When a workbook is opened by macro, no macro warning message should appear.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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