I protected the macro as stated earl
and saved the spreadsheet

I emailed the spreadsheet to a user
They entered some data into the spreadsheet and
then tried to save the spreadshee

here is the error message they received

You cannot save to this file format when the VBA projec
is protected

You may unprotect the VBA project by choosing in Projecties Comman
on the Visual basic editor's tools menu and entering the password for
the active project

I want to protect the macro, but allow users to change and save the data

George