How do I put read only warning on macros

[ghrek]

Hi

I have macros that are shortcuts to books that numerous people use.

I know how to record the macro to open the book but dont know what to add when its opening as a "READ ONLY" as in the message box warning it read only.

Can anyone help?

 

[steve the fish]

Like this for example:

Dim wb As Workbook

Set wb = Workbooks.Open("C:\Steve\Desktop\whatever.xlsx", ReadOnly:=True)

 

[ghrek]

Thanks for that.

I put this in as a macro and keep getting file dont exist but it does.

Sub Macro7()
'
' Macro7 Macro
'
Dim wb As Workbook

Set wb = Workbooks.Open("\\lo-nas01\arrivashared\Passenger Accounts\SHARED\passacc\Excel\passacc\CCREFUND LOROL ", ReadOnly:=True)
'
End Sub

Is it because someone has it open already?

 

[steve the fish]

Put the extension in (eg .xlsx) and i doubt your file name ends in a space.