Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default SaveAs didn't work in VB protected mode

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Work with my 97-2003 Excel version in Compatibility Mode? Quincy Excel Discussion (Misc queries) 0 January 6th 10 08:31 PM
I can not get spelling to work when in (compatibility mode) Dean New Users to Excel 0 June 1st 07 09:57 PM
save as mode doesnt work seachange49 Excel Discussion (Misc queries) 0 April 26th 06 09:26 PM
Allow user to run a macro in protected mode Jean Cloutier Excel Discussion (Misc queries) 2 November 23rd 05 08:55 PM
Unable to open excel sheet in Protected mode from VB 6.0 ourspt Setting up and Configuration of Excel 0 January 26th 05 11:07 AM


All times are GMT +1. The time now is 06:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"