+ Reply to Thread
Results 1 to 12 of 12

Macros Security

  1. 06-03-2012, 02:30 PM #1
    The Skipper
    The Skipper is offline
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Macros Security

    Hopefully I am in the correct forum. This really isn't a programming question so I posted it here.

    I copied an .xlsm file from my desktop running Windows XP, where is loads and works perfectly to a Flash Drive and then copied to my laptop running Windows 7 where it opens, but no matter how I configure the security settings it will not run the macros that were in the transferred file.

    I can write and execute new macros using the file, but if I save the file and reopen it the macos become inoperable. Any Suggestions?

    Thanks !!
    Reply With QuoteRegister To Reply
  2. 06-03-2012, 02:33 PM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Macros Security

    Do you have the same version of XL on both machines? Is the one that doesn't run the macros a full version of Excel? Does the Student version of Excel support VBA? I'm thinking you have missing .dll's on the machine that you want it to work on.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 06-03-2012, 02:36 PM #3
    The Skipper
    The Skipper is offline
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Re: Macros Security

    using the same version of Excel on both computers. Not the student version.
    Reply With QuoteRegister To Reply
  4. 06-03-2012, 03:06 PM #4
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macros Security

    Hello The Skipper,

    You've set the security level on your Windows 7 machine to medium, right?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  5. 06-03-2012, 03:16 PM #5
    The Skipper
    The Skipper is offline
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Re: Macros Security

    Please tell me how to check/change the Windows 7 Security Level.
    Reply With QuoteRegister To Reply
  6. 06-03-2012, 03:21 PM #6
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macros Security

    Hello The Skipper,

    In Excel: Tools>Macro>Security - Medium
    Reply With QuoteRegister To Reply
  7. 06-03-2012, 03:26 PM #7
    The Skipper
    The Skipper is offline
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Re: Macros Security

    Tools in Excel 07? Where is that?
    Reply With QuoteRegister To Reply
  8. 06-03-2012, 03:40 PM #8
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macros Security

    Hello The Skipper,

    Bring up an excel workbook, then up on the top menu bar you have: file, edit, view, insert, format, and then tools.

    Click on tools>macro>security - medium
    Reply With QuoteRegister To Reply
  9. 06-03-2012, 03:45 PM #9
    The Skipper
    The Skipper is offline
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Re: Macros Security

    Thank you !!
    Reply With QuoteRegister To Reply
  10. 06-03-2012, 04:00 PM #10
    The Skipper
    The Skipper is offline
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Re: Macros Security

    I don't think Excel 07 has "file, edit, view, insert, format, and then tools" across the top. I believe that was an earlier version.
    Reply With QuoteRegister To Reply
  11. 06-03-2012, 04:40 PM #11
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Macros Security

    Hello The Skipper,

    Your version is 2003 but your operating system is Windows 07 - or isn't it?

    But you can still set your security in Excel 2007 and 2010 - you just have to hunt for it.

    I rejected 2007 after about two months of it and reinstalled 2003 so I can't be more specific.
    Reply With QuoteRegister To Reply
  12. 06-04-2012, 03:17 AM #12
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Macros Security

    The skipper you are staing in your profile that you use Excel 2003.

    Read this
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1