protected view

Hello. So I have a workbook that tracks break times. It does this by counting down from 20 minutes in column E when a value is entered in column A. It is updated every single second. However, when a workbook that is in Protected View and needs to have "Enable editing" selected opens then I get...

I have the following code which is supposed to loop through all open workbooks which are currently in "Protected View" (the yellow bar where you need to click "Edit" to be able to use the workbook) and it only loops through one or two, then stops and I don't know why. 'protected view fix Dim...

OBJECTIVE: I have a Word file with 275 linked fields to an Excel file. I would like the user to be able to select any range in the Word file and update selected links, and I would like this process to occur without the Excel file opening/closing for each individual link. CURRENT SOLUTION...

I have several .doc files with .xls files (both 97-2003 versions) embedded. When I open the .doc file in Word 2010 and try to open the .xls file I get the following error message: "Microsoft Word can't start the application required to open this object. An error occured and this feature is no...

I have an excel file that will be opened and accessed by hundreds of people, this file is only accessible through a database program so it is not on a network drive per se. The file has some simple code to hide the ribbon and formula bar, however if the file is opened and trust center settings...

Hello, It seems my Adobe Report Builder v.5.0.4 doesn't refresh any reports anymore in Excel v.14. I see 2 errors, I think one due to the other: 1) If I hit the refresh all button in the Add-in tab or in the Request Manager all my tabs in the workbook jump to protected view. 2) If I refresh a...

Hi there, I have a rather large workbook which I sell licensed access to. I have a licensee who has purchased access for four users but wants the functionality for additional admin staff to be able to open the workbook for printing purposes in the event licensed users are not available. I have...

Hi - I've got a file that works fine on my computer. When I email it to anyone with 2010 and they open it from their email account (Outlook 2010), the file automatically opens up in 'Protected Mode'. If the user selects "Enable Editing" the user receives 'Run Time error 91: Object variable or...

Treading in unfamiliar waters yet again... We have a spreadsheet that does alot in our opinion. It had an issues list on one sheet. We moved that content to Sharepoint as a Sharepoint list to allow for more access of data entry...seemed smart. I saw how I could create an IQY file and then...

I am using Office 2010. Opening the workbook works fine when not in Protected View. However, anytime it is in Protected View (opening from email) the user gets the following error after clicking Enable Editing: Run-time error '91': Object variable or With block variable not set I ran the...