Re: [ExcelVBA] VBA Reference to a protected workbook

This should help you: http://www.google.com.au/search?q=excel+vba+password+open+workbook

Regards

Paul

Sent from my iPhone

On 14/06/2012, at 20:49, "abuali06062011" <abuali06062011@yahoo.co.id<mailto:abuali06062011@yahoo.co.id>> wrote:



I have a formula that i created with vba. this formula reference to workbooks those have a same password. every time it ask to supply password. how can i supply password atutomatically from my vba?
please, i need your help. thanks





[Non-text portions of this message have been removed]



------------------------------------

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ExcelVBA/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/ExcelVBA/join
(Yahoo! ID required)

<*> To change settings via email:
ExcelVBA-digest@yahoogroups.com
ExcelVBA-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
ExcelVBA-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/