Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Disable automatic saving of VB Project

I have a workbook containing a VB Project with a macro that adds a
reference to a dll if this reference is not yet there. The VB Project
is signed.
Now the problem is if somebody else runs this macro and saves the
workbook the following error message is displayed:
"You have modified a signed project. You do not have the correct key to
sign this project. The signature will be discarded."
Obviously excel consideres adding a reference as changing the VB
Project and tries to save this change.

Is there a way to "discard the change" and prevent the VB Project from
being saved again, so the signature won't disappear?

Alternatively, is there a way to add the reference without changing the
VB Project?

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
disable automatic outlook sleere Excel Discussion (Misc queries) 1 May 23rd 09 05:57 PM
how to disable automatic nr conversion Mau Excel Discussion (Misc queries) 2 October 10th 07 08:31 AM
Disable automatic GETPIVOT news.microsoft.com Setting up and Configuration of Excel 3 July 10th 06 09:19 PM
Problem saving with VBA project protected. JAMES T. Excel Programming 6 March 19th 05 11:44 AM
Saving a spreadsheet with a protected VBA project Nexxas Excel Programming 1 May 13th 04 04:48 PM


All times are GMT +1. The time now is 07:01 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"