Im having great difficulty figuring out the new security features with Excel 2003.
Im using a macro that opens a template file which is pre-locked for viewing only using the setting found under 'tools-options-security tab'.
The macro uses the writeResPassword parameter when opening the template to allow editing. iI then need to save a copy of the template file with changes BUT without any protection whatsoever. I cant for the life of me figure out how to turn off or delete the password protection.
Ive tried the setting writeResPassword to "" when saving, and various other options such as using unProtectSharing, but all seem to do absolutley nothing.
The other option would be to protect the individual sheets and unlock them all on opening, but Id rather not do that as it seems very clumsy.
Frankly i think Microsoft have done a bit of an overkill with the protection features, as now its not user friendly in the slightest.
Anyone got any ideas please??
Danger shines like sunshine in a brave mans eyes!