Save and save as in excel

[salahianoo]

I have a basic form of excel sheet how can I make the user to save as this work book not saving on it
Just saving in new sheet??

 

[dermie_72]

When you go to save the document, click on the tools button next to save

Select General Options.
Enter a password to modify.
You can also check read-only recommended.

This way they need to know the password to save over this file, otherwise they will only be able to save as.

 

[salahianoo]

I know this way but it doesn't help me because I want to make audit trail
So there is not another way?

 

[salahianoo]

When you go to save the document, click on the tools button next to save
View attachment 107278
Select General Options.
Enter a password to modify.
You can also check read-only recommended.
View attachment 107279

This way they need to know the password to save over this file, otherwise they will only be able to save as

I know this way but it doesn't help me because I want to make audit trail
So there is not another way?

 

[dermie_72]

I know this way but it doesn't help me because I want to make audit trail
So there is not another way?

You didn't mention anything about an audit trail in your initial post. So forgive me if I didn't consider this when replying.
You could always use the

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As   Boolean)

this worksheet event to action when you save the file. Then add your code to do what you want when they hit save.