PDA

View Full Version : Read Only File


priya123
04-09-2007, 04:03 PM
Is that possible that I can make an excel file as a read only through code... and if needed should be opened by giving password ?

Edit Lucas: Cross posted (http://www.ozgrid.com/forum/showthread.php?t=66969).

Click here (http://www.excelguru.ca/node/7) for an explanation of cross-posting
Bob Phillips
04-09-2007, 04:33 PM
Do you mean the current attribute, or permanently. If the former
ActiveWorkbook.ChangeFileAccess xlReadOnly
Brandtrock
04-10-2007, 01:47 AM
Cross posted HERE (http://www.ozgrid.com/forum/showthread.php?t=66969)
Aussiebear
04-10-2007, 02:35 AM
Hmmm... cross posted huh? Well I for one can feel a whole lot of interest in this post just gone out the window.
lucas
04-10-2007, 06:47 AM
I would suggest a search before you even post......
From a search of this forum.....read only (http://www.vbaexpress.com/forum/showthread.php?t=12201&highlight=read+only)

priya123,
Click here (http://www.excelguru.ca/node/7) for an explanation of cross-posting