+ Reply to Thread
Results 1 to 3 of 3

Workbook opens in Protected View

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    Foster City, CA
    MS-Off Ver
    Excel 2010
    Posts
    37

    Workbook opens in Protected View

    I've been building an excel workbook with several tabs and many macros. At some point the file started opening in protected view. Is there anyway to trouble shoot the file to find the root cause of this?

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Workbook opens in Protected View

    Did you tried

    Explorer > File > Properties.. > General > Unblock

    Try once.. as you want to enable only for a specific file..

    If you need all files (Never Protected mode ir-respective of source or any specific folder) let us know..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Registered User
    Join Date
    01-02-2013
    Location
    Foster City, CA
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Workbook opens in Protected View

    I wasn;t able to follow the instruction. Where is 'Unblock'?

    I really have two issues.
    1. Why is a file I created lunching in Protect mode on my computer? If I can figure out your solution, will that stop the file from coming up in protect mode even when I change the file name?
    2. Can I prevent this file from coming up in Protect Mode when I email it to others?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can't edit a file that opens in Protected View mode
    By AndrewMac in forum Excel General
    Replies: 4
    Last Post: 12-30-2022, 03:07 AM
  2. How to view a custom view when the worksheet is protected?
    By JulesJam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-06-2006, 10:20 AM
  3. [SOLVED] Change Options under Tools>Optioons>View Tab When User Opens Workbook
    By Minitman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-30-2005, 01:05 AM
  4. Replies: 1
    Last Post: 07-27-2005, 05:25 PM
  5. [SOLVED] Workbook opens really small after protected
    By Mark Stephens in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2005, 02:05 PM

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