Open second spreadsheet with certain permissions via onopen

  • Thread starter Thread starter Maver1ck666
  • Start date Start date
M

Maver1ck666

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,,True)

The "True" opens the wokbook in readonly mode
 
Back
Top