Apparently not possible?
Hi Bill,
Oddly enough, I tried the same thing you did, only at home. I just set up a
read only hidden file, then I wrote to it from another file using code, to
change its contents. It worked just fine. At home I am running Office 2003
with Win XP, just like at work.
I'm going to try this test tomorrow at work and see if it works. If it does,
then something else is at play that I'm not accounting for.
Thanks for your help; I may post back again depending upon what I find...
"Bill Renaud" wrote:
Strange. I set this up as a Read-Only file (using Explorer) on Windows ME
with Excel 2000 SP-3, and it works fine on my machine. I can open the file,
unhide the workbook, make a change, hide the workbook, then exit Excel
without getting any prompts.
What version of Excel are you running?
--
Regards,
Bill Renaud
|