Save Command Button Code

[Amitdas]

Hi Expert,
I am new in a Excel. I have created a trainee project for my learning.
Now i want to sate a Save Command Button. Which VBA code i can do this.

Thanks in Advance.

 

[MARK858]

Have you tried using the macro recorder to see what code it gives you?

 

[Amitdas]

Thanks I have Tried and it is Working when I Click save button,
after Clicking okay of a Notification which is appeared when i click save button
But when i click cancel Button in the Notification Dialog box then Showing "Run time error 1004"
How can solved this


I attested hear with a Problem

https://1drv.ms/u/s!AhmcunkKg31pjjwOgDzksCZXsir0

https://1drv.ms/u/s!AhmcunkKg31pjjtRSQcO8prHbW5a

Thanks Again.

 

[MARK858]

To turn off document inspector....

Go to File in the upper left hand corner,
then Options > Trust Center > Trust Center Settings > Privacy Options
then un-check the check box that says "Remove personal information from file properties on save",
then hit OK.

 

[Amitdas]

You are grate.
It has been fixed now.