Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Office general help » Protected View

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Protected View

Resolved · Medium Priority · Version 2010

Reply Wed 8 Jun 2011, 16:55Delegate Natalie said...

Natalie has attended:
Excel Advanced course

Protected View

hi,

Everytime i open a saved document, be it word, excel, powerpoint or access i always gets the yellow bar at the top labeled protected view, and i have to click enable editing. Is there a way i can stop this bar appearing, and be able to edit straightaway?
Thanks,
Natalie

For upcoming training course dates see: Pricing & availability

Reply Thu 9 Jun 2011, 21:02Trainer Rodney said...

RE: Protected View

Hello Natalie,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding the protected view settings.

Microsoft introduced the protected view mode to open potentially dangerous files without any security prompts to minimise any harm coming to your computer. You can view these settings by doing the following:

Click File Tab > Excel Options > Trust Center > Trust Center Settings > Protected View

There are 4 settings which are all active for your protection. You have to decide whether to disable these settings by removing the ticks.

You may aslo want to check the Trusted settings located at the top of this section. Please refer any issues you have regarding security with someone from your IT department as they will have certain policies in place which everyone has to follow. They will help you with the correct setup for your computer.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Microsoft Office articles

· Growing with Microsoft Office as it leaves behind its teenage years
· How To Paste Without Slicing Your Fingers
· Getting A Job With Help From Microsoft Office
· Find Out About The New Common Features In Office 2010
· Uses for Office, outside the Office

Please browse our web site to find out more about
it training providers and other Microsoft training courses.

Microsoft office tip:

Prevent macros from running when you start Applications

Macros are automated programs that can help you speed up your work. They can be embedded in caommands like AutoExec which will make them run as soon as an application like MS Word or MS Access are launched.
Sometimes it is useful to be able to switch off this function, and then can be done by the following method.
Hold down the SHIFT key when you click on the icon to start the program. This will suppress any automated macros.

View all Microsoft Office hints and tips