Save As and Security

[JDU]

I am using the following code to save a file automatically through a macro.

If bExcelFileWithOutSameName = True Then

xlsheet.SaveAs Path & "\" & strFileName & ".xls"
End If

However when I open the newly saved file, it opens with a security setting of Medium since the security setting of the file that contains the macro that I use to create/save this new file is medium. How can I save it with a security setting of high and thus not get the dialog box of disabling, enabling macros.

Thanks.

 

[SkipVought]

JDU,

I believe that the security setting is for YOUR Excel application and NOT for the File.

Each user has his/her own security setting.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[JDU]

Are you sure about this because I can open files that do not have macro's with a security of high and I can open files with macro's with a security of medium with the dialog box that asks for disabling/enabling macros.
Thanks.

 

[SkipVought]

If you do Tools/Macro/Security and change you setting to HIGH.

Then try to open one of those workbooks you previously opened with macros enabled.

The only way that you could, is if you had authorized that certificate as a trusted source some time in the past.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[JDU]

Thanks.

 

[Chattin]

I'm sure that the security setting is application level rather than being set for each wokbook as SkipVought said so I don't think you can specify for each w/b (IMHO)