LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Saving while vba is passworded

Hello all,

I have a button to which is assigned the following code:

ActiveWorkbook.Save

Now i also need to protect my vba from user sight because
it contains passwords,so this is protected with a
password.

Now when i click the button to save i get a message
saying that this cannot be done with protected vba.

Is there some vba that could be added to the above to
allow the file to be saved but to maintain protection of
the programming?

Some passwords have been discovered when debug errors
expose the programming, and when people have been
medling, i need to stop this.

Very grateful of any help

Cheers

Joe

 
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
passworded access hiriearchy Resi Excel Discussion (Misc queries) 1 March 26th 09 12:06 PM
Passworded Sheets ? JacobsBabtie Excel Discussion (Misc queries) 2 May 5th 06 01:36 PM
Passworded Spreadsheet Lakebum Excel Discussion (Misc queries) 7 April 8th 06 12:36 AM
Linking to a passworded workbook PeterD Links and Linking in Excel 0 July 18th 05 12:50 AM
Passworded Macro!! sh0t2bts Excel Worksheet Functions 1 December 3rd 04 05:03 PM


All times are GMT +1. The time now is 12:10 PM.

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

About Us

"It's about Microsoft Excel"