Protected VB code - Run-time error

A

AvalancheMike

My code runs fine, however when I protect the code from viewing I get the
following run-time error:

Method 'SaveAs' of object'_Workbook' failed

Here is the only code I have for saving the file:
ActiveWorkbook.SaveAs Filename:=SourceName, FileFormat:=xlTextPrinter,
CreateBackup:=False

TIA
 
J

JLGWhiz

Couldn't duplicate the error. Mine saves as without a problem and retains
the protection.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SaveAS dialog box gives run time error 1004 in Excel VBA 3
How do I convert a macro that was created in 2003 Excel to 2007 8
VSTO C# add in Outlook.Appointment error 0
Protecting VBA (Excel) code 5
Simplify save code 11
Export worksheet to .csv 3
Error on ActiveWorkbook.SaveAs method 3
SaveAs *.txt - Outputting with Text quantifiers 4

Top