read-only default
 

Hi everypne, I have a spreadsheet with a hyperlink to a number of othe
spreadsheets, all of which I want to be read only, ie: the user canno
alter the information premanently.

What I dont want is for the user to have to click" open file read-only
on each spreadsheet. Is there a way, using VBA to make each fil
read-only as a default, which wont require the user to confirm the fac
?

Many thanks in advance.

Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=27039