+ Reply to Thread
Results 1 to 8 of 8

Active content error allowing unauthorised access to sheets

  1. #1
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    329

    Active content error allowing unauthorised access to sheets

    Hi I've set up my document to always load up a certain sheet and then the user has to enable macro's and enter a password to access any of the other sheets. However for some reason I sometime get "Some active content has been disabled" which allows the user to go on any sheet without having to put any password in??

    Is there anyway to stop this?

    Cheers
    Last edited by Throughstream; 07-13-2019 at 02:08 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    28,279

    Re: Active content

    Can you please share a sample workbook displaying the problem?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    329

    Re: Active content

    Hi hmmm not easily as it contains sensitive information. I could give you the coding from “thisWorkbook” if that helps?

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    28,279

    Re: Active content

    That would be a start, however might not be enough. Can you produce a desensitised copy and share that?

    Is the workbook being saved as .xlsx at any point instead of .xlsm?

    Are you really still using Excel 2007?

  5. #5
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    329

    Re: Active content

    Hi sorry I know it would make it easier but I wouldn't feel comfortable even producing a desensitised copy unless it was a last resort.

    Please Login or Register  to view this content.
    Haha well I use 2007 at home and 2010 at work.

    The work book is saved as both a .xlsm and a .xlsx at the same time in two locations however it was doing the "active content error" before I started saving it as a .xlsx as well.

    Could it just be that the admin's at my work have made it so that it automatically disabled active content?
    Last edited by AliGW; 07-13-2019 at 01:51 AM. Reason: Code tags corrected.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    28,279

    Re: Active content

    I think the admins at work need speaking to first - you need to eliminate that before trying to troubleshoot any further.

    By the way, your thread title is a bit vague - can you please make it a bit more detailed? Thanks.

  7. #7
    Forum Contributor
    Join Date
    01-21-2017
    Location
    England
    MS-Off Ver
    2007
    Posts
    329

    Re: Active content

    No problem, is there any way to make it so the document doesn’t open any sheets or only opens a specific sheet unless active content is enabled?

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    28,279

    Re: Active content error allowing unauthorised access to sheets

    In answer to your latest question - possibly. Make that part of your improved thread title. You'll have to wait for a VBA expert. Most people aren't up at this time on a Saturday!

    EDIT: Title MUCH better - thanks.

+ 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