password protect excel doucument automatically

A

Ambrose

I created access form which have a command button. I want to get excel
document and passowrd protect the document when I click on the command
button. Please do you have some idea?
 
M

MacDermott

Open Excel and record a macro protecting a document.
Look at the code it creates for clues on how to code it from Access.
 
Top