UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Enable Editing, Any Version    
 
   
arun.ms0910
post Jun 22 2019, 05:36 AM
Post#1



Posts: 17
Joined: 19-June 19



Hi Frnds,

When i try to open my excel workbook its shows "Enable Editing" how to disable in vba anyone please help me...iconfused.gif
Attached File(s)
Attached File  Untitled.png ( 21.33K )Number of downloads: 3
 
Go to the top of the page
 
jleach
post Jun 22 2019, 05:58 AM
Post#2


UtterAccess Editor
Posts: 10,021
Joined: 7-December 09
From: St Augustine, FL


This is because the directory you're opening from (or the file itself) is not added to the machine's Trusted Locations.

You can take a look there and trust the location, then you won't get the yellow banner anymore.

--------------------
Go to the top of the page
 
DanielPineault
post Jun 22 2019, 06:12 AM
Post#3


UtterAccess VIP
Posts: 6,717
Joined: 30-June 11



This is a security 'feature'. You cannot use VBA in the workbook to get around it, otherwise that would defeat the whole purpose. Although not recommended you can disable to warning by changing the setting in the Trust Center (File -> Options -> Trust Center -> Trust Center Settings -> Protected View and then uncheck Enabled Protected View for files originating from the Internet). You can read all about Protected View by looking over https://support.office.com/en-us/article/wh...43-2bbcdbcb6653.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    21st July 2019 - 07:48 AM