I want to protect rather hide my macro from users and at the same time
I want them to see and use workbook and save the work.When I protect my
project in VBE it does not allow me to save /and save as beacause it
asks first unprotect the sheet first.If I save the work book by putting
a password for read/modify access it exposes my macro to the users.

Any quick solution will be highly appreciated.
ST

Protecting the VBA Project should not affect the Workbook. Have you done it correctly?

In the VB Editor, use the Tools Menu VBAProject Properties Protection.

Then check the Lock project for Viewing box.

Type a password & confirm it.

Click OK

Close & Save the Workbook.

Your macros will now only be viewable with this password