+ Reply to Thread
Results 1 to 8 of 8

File opens in Design Mode and unable to run macro

  1. #1
    Registered User
    Join Date
    08-08-2012
    Location
    UAE
    MS-Off Ver
    Excel 2007
    Posts
    43

    File opens in Design Mode and unable to run macro

    Some macro files run without problems yet some open in Design Mode and I am unale to deactivate the mode to run macros. For other users this works fine. Btw the macros are run through buttons...not through SHFT-CTRL combination. What could be the issue?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: File opens in Design Mode and unable to run macro

    are you using the same version of excel as the other users?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    08-08-2012
    Location
    UAE
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: File opens in Design Mode and unable to run macro

    Yes we all use excel 2007

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: File opens in Design Mode and unable to run macro

    then I reckon it's probably your activex settings in trust center

  5. #5
    Registered User
    Join Date
    08-08-2012
    Location
    UAE
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: File opens in Design Mode and unable to run macro

    That has "Prompt me before enabling all control with minimal restrictions" checked

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: File opens in Design Mode and unable to run macro

    what do other users have set? probably no prompt

  7. #7
    Registered User
    Join Date
    08-08-2012
    Location
    UAE
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: File opens in Design Mode and unable to run macro

    exactly the same. Have checked the settings

  8. #8
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: File opens in Design Mode and unable to run macro

    are you seeing a prompt when you open those files? do you have the same patches and service packs applied to your office installation?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1