I want to enable the Save and saveas option only for the file name "Rhel.xlsx" and want it to disabled for every other file name but its not working

[siddo]

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If sfilename ="Rhel.xlsx" Then
Cancel = False
Else
Cancel = True
MsgBox "Contact Author"
End If
End Sub

 

[Fluff]

You will need to put the code in the Rhel workbook & save it as an xlsm file.

 

[siddo]

You will need to put the code in the Rhel workbook & save it as an xlsm file.

Yes, have saved this code in Thisworkbook section with the file name Rhel.xlsm so basically I want to disable save and saveas for Rhel.xlsm but not for Rhel.xlsx though its not working

 

[Fluff]

The code will only work on the workbook it's in, so it will not affect the Rhel.xlsx workbook.

 

[siddo]

Yes, have saved this code in Thisworkbook section with the file name Rhel.xlsm so basically I want to disable save and saveas for Rhel.xlsm but not for Rhel.xlsx though its not working

I have created a macro file to which if certain outputs are feed in Rhel.xlsm file it computes and generate other file named Rhel.xlsx

 

[siddo]

The code will only work on the workbook it's in, so it will not affect the Rhel.xlsx workbook.

I have created a macro file to which if certain outputs are feed in Rhel.xlsm file it computes and generate other file named Rhel.xlsx

 

[Fluff]

Sorry but I don't understand what you are saying.

 

[siddo]

Sorry but I don't understand what you are saying.

I have created a macro file for my organisation in which if you put certain database outputs it computes the whole thing and returns the result in Rhel.xlsx so all I want to do is I dont want a user to save My macro workbook I just want them to give the permission to save Rhel.xlsx file. I hope you understand.. Thanks for the help anyways.

 

[Fluff]

How are you creating the Rhel.xlsx file?

 

[siddo]

How are you creating the Rhel.xlsx file?

It gets created automatically when database output gets feed in to the xlsm file