![]() |
Protected VB code - Run-time error
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 |
Protected VB code - Run-time error
Couldn't duplicate the error. Mine saves as without a problem and retains
the protection. "AvalancheMike" wrote: 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 |
All times are GMT +1. The time now is 12:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com