When I open a certain spreadsheet, I want it to be able to do the following:

On open, the spreadsheet opens another speadsheet on my network but it opens
either hidden to the user or minimised and read only so that no changes can
be made.

Sounds a bit strange but its because the second spreadsheet contains loads
of lists which the first spreadsheet references (dynamic name ranges for
validation lists). but I dont want the second spreadsheet to be altered.

Thanks in advance for your help.

Kind regards,
Mawver1ck666

In the open event of your workbook (double -click on thisWorkbook in the VBA
project manager, select 'workbook'in the left-hand combo and 'open' in the
right-hand combo) enter:
application.Workbooks.Open(YourPathAndFileName,,Tr ue)

The "True" opens the wokbook in readonly mode

"Maver1ck666" wrote:

When I open a certain spreadsheet, I want it to be able to do the following:

On open, the spreadsheet opens another speadsheet on my network but it opens
either hidden to the user or minimised and read only so that no changes can
be made.

Sounds a bit strange but its because the second spreadsheet contains loads
of lists which the first spreadsheet references (dynamic name ranges for
validation lists). but I dont want the second spreadsheet to be altered.

Thanks in advance for your help.

Kind regards,
Mawver1ck666