One of my colleagues has developed a spreadsheet with macros written in VB and others recorded to perform some quite complex analysis. <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>
He has password protected the workbook but the file needs to be sent out on a CD ROM and saved onto another network. This results in the password protection being lost thus allowing anybody, even unwittingly, to mess it up. <img src=/S/disappointed.gif border=0 alt=disappointed width=15 height=15> Is there anyway around this?
The only idea around this so far is to have the new users save the file as a template, so if they make a pig's ear of it, they can start again.
If this is the solution, is it possible to get the CD ROM to place the file in their template folder without the normal Excel user easily redirecting the file when they copy it from the CD.