Excel 2000: Sending Password protection to new book

[kadam]

Hi - I have a workbook ("Template&quot which creates quotes in a separate workbook ("Quote&quot. The Quote workbook is created new every time - I built it this way so that customers wouldn't receive quotes with macros attached.

I've been able to lock the Quote workbook, but have not been able to get it to password protect. All I currently use is...

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

Remember - all the macros are in Template, and its the Quote workbook that needs to be fully locked down.

Ideas? I'm at my limit of macro knowledge here...

Many thanks - Kadam.

 

[venkman]

protect takes a password for it's first paramater. Is there a reason you are not using this?

-Venkman

 

[kadam]

I now think I can do it with SendKeys...

Application.SendKeys ("%T&quot
Application.SendKeys ("P&quot
Application.SendKeys ("P&quot
Application.SendKeys ("abc~&quot
Application.SendKeys ("abc~&quot

 

[kadam]

Thanks Venkman - didn't know it existed... easier than SendKeys...

 

[venkman]

you should use the visual basic help. It's a little more difficult than I would like to find the topic you are looking for, but once you find the right topic, it's great at answering these type of questions.

-Venkman