Open second spreadsheet with certain permissions via onopen
 

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

Open second spreadsheet with certain permissions via onopen
 

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