Beatrix
07-15-2010, 07:54 AM
Dear All ,
I want to use a VBA code to open an excel workbook as readonly. I've found a code which is working but it doesn't run when I open the workbook, I open the workbook and run the macro then it makes it readonly..Do you have any idea how can I get it to run as soon as the spreadsheet is opened.
Sub OpenReadonly()
Workbooks.Open fileName:="U:\MIS\test.xls", ReadOnly:=True
End Sub
your help would be much appreciated..
Regards,
Yeliz
I want to use a VBA code to open an excel workbook as readonly. I've found a code which is working but it doesn't run when I open the workbook, I open the workbook and run the macro then it makes it readonly..Do you have any idea how can I get it to run as soon as the spreadsheet is opened.
Sub OpenReadonly()
Workbooks.Open fileName:="U:\MIS\test.xls", ReadOnly:=True
End Sub
your help would be much appreciated..
Regards,
Yeliz