SaveAs didn't work in VB protected mode

M

manfred

Hey, the ...SaveAs ... FileFormat:=xlExcel4Workbook ...
command works fine until the project is not protected.

Does someone know how to make a copy of the original
workbook (in vb) without copying the macros ?

or

how to unprotect the VBProject-Objekt (in vb).

thanks manfred
 

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

Copying in sheet with protection with the use of a macro 5
VB Editor Access 2
Multiple sheet unprotection not working 9
Saving File with the VB Modules protected giving me an error. Than 3
Protect / Unprotect Sheet in Share Workbook Excel 1
Problem in adding macro to ribbon through Add-in 7
Module protection & Shell issues 1
Programmaticlly sign and password protect a VBA Project in Excel 2 6

Top