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    
post Jun 22 2019, 05:36 AM

Posts: 19
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
post Jun 22 2019, 05:58 AM

UtterAccess Administrator
Posts: 10,644
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.

Jack D. Leach
Founder & CEO
Dymeng Services Inc.
Business Software Solutions
Go to the top of the page
post Jun 22 2019, 06:12 AM

UtterAccess VIP
Posts: 7,435
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-2020 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://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    6th August 2020 - 10:35 AM