Saving a macro

[Guest]

I have an excell file which i want to be able to share, it has macros that
allow times to be added and saved. i was wondering if there was a way to make
this a file which cannot be altered, only info. added. like a template file,
to prevent deletion of the macros?

 

[Scoops]

I have an excell file which i want to be able to share, it has macros that
allow times to be added and saved. i was wondering if there was a way to make
this a file which cannot be altered, only info. added. like a template file,
to prevent deletion of the macros?

Hi Bill

You can protect your code in the vba editor by right-clicking the
Project name in the explorer window > VBAProject Properties >
Protection tab > check Lock project for viewing > add a Password (and
don't forget it).

Your code can't be accessed now but the macros can still be disabled
at startup.

Regards

Steve