I have a macro that saves my spreadsheet (let call it "Spreadsheet_A") as a
spreadsheet with a different name (ie. "Spreadsheet_A_10_30_2005") but the
same password to open the file.

Other users cannot open Spreadsheet_A_10_30_2005 without my password (and I
do not believe that they have the sophistication to download a program to
remove the password protection). However, they are currently able to view my
macros, which contain the password. I know that I can password protect my
macros by going to Tools-VBA Project Properties, but is there a way to write
a macro to automatically password protect my macros upon exit? Or upon using
"save as"?

Thanks!

One more thing...I keep Spreadsheet_A on my C drive (where no one else can
access it) and I am frequently editing my macros (so I would prefer not to
always require a password to view the macros). Spreadsheet_A_10_30_2005,
however, is saved to our shared drive, which is why I want to use a macro to
password protect my macros. Thanks,
Noah

"Noah" wrote:

I have a macro that saves my spreadsheet (let call it "Spreadsheet_A") as a
spreadsheet with a different name (ie. "Spreadsheet_A_10_30_2005") but the
same password to open the file.

Other users cannot open Spreadsheet_A_10_30_2005 without my password (and I
do not believe that they have the sophistication to download a program to
remove the password protection). However, they are currently able to view my
macros, which contain the password. I know that I can password protect my
macros by going to Tools-VBA Project Properties, but is there a way to write
a macro to automatically password protect my macros upon exit? Or upon using
"save as"?

Thanks!

There is no provision for it in the Object model.

The usual suggestion is to use SendKeys

See Bill Manville's code:

http://tinyurl.com/926n9

--
Regards,
Tom Ogilvy


"Noah" wrote in message
...
One more thing...I keep Spreadsheet_A on my C drive (where no one else can
access it) and I am frequently editing my macros (so I would prefer not to
always require a password to view the macros). Spreadsheet_A_10_30_2005,
however, is saved to our shared drive, which is why I want to use a macro
to
password protect my macros. Thanks,
Noah

"Noah" wrote:

I have a macro that saves my spreadsheet (let call it "Spreadsheet_A")
as a
spreadsheet with a different name (ie. "Spreadsheet_A_10_30_2005") but
the
same password to open the file.

Other users cannot open Spreadsheet_A_10_30_2005 without my password
(and I
do not believe that they have the sophistication to download a program
to
remove the password protection). However, they are currently able to
view my
macros, which contain the password. I know that I can password protect
my
macros by going to Tools-VBA Project Properties, but is there a way to
write
a macro to automatically password protect my macros upon exit? Or upon
using
"save as"?

Thanks!

How about a macro from another workbook?

--
Don Guillett
SalesAid Software

"Noah" wrote in message
...
I have a macro that saves my spreadsheet (let call it "Spreadsheet_A") as
a
spreadsheet with a different name (ie. "Spreadsheet_A_10_30_2005") but the
same password to open the file.

Other users cannot open Spreadsheet_A_10_30_2005 without my password (and
I
do not believe that they have the sophistication to download a program to
remove the password protection). However, they are currently able to view
my
macros, which contain the password. I know that I can password protect my
macros by going to Tools-VBA Project Properties, but is there a way to
write
a macro to automatically password protect my macros upon exit? Or upon
using
"save as"?

Thanks!