Enable Editing Code

[Mozzz]

When I open a file I get the "Enable Editing" Button which I have to select to be able to run a macro that I wrote. would like to be able to open the file and enable editing as part of my Maco.

What is the VBA code to "Enable Editing"?

Help

 

[SydneyGeek]

Have you placed the file in a Trusted Location? If so, you should not be getting that message. I don't think that there is a VBA option for overriding those settings; otherwise the settings themselves would be useless.

Denis

 

[Mozzz]

I receive a Time Sheet from our outside Slsman every morning. I have written a small maco that takes his data and adds it to the main sheet so we can convert the whole month into a pivot table. I would like to be able to open the email excel attachment and just run my macro.

I am new to the forums, not sure if I can send you the file or not.

I am pretty new to excelVBA so I am not up on putting an email or attachment into a trusted site. How exactly would I do that?

Thanks,

 

[SydneyGeek]

To set up a trusted location (2007) -- 2010 is similar but I don't have that on my PC.
To to the Excel Options.
Click on Trust Center
Click on Trust Center Settings (button on right)
Click on Trusted Locations
Bottom right, Add New Location
Browse to the folder that you want to trust (eg Desktop, then click on My Documents). Make sure that Trust subfolders is checked, then OK.

Now, any documents in this location will open without security prompts.
Email attachments will always give you the editing message (are you using 2010?) until you save them in a trusted location.

Denis

 

[Mozzz]

Yes, I am using 2010. Not a big deal I will just have to enable and then run the macro. Still turns a 5 minute job into about 30 seconds.

Thanks,

 

[Mozzz]

Thanks, I will give it a whirl! I am running 2010.