I am new to this Forum and I Need some help with VBA codes.
I am completely new to VBA and Macros. All i know now is to insert ActiveXcontrols and enter the code.
Please help me withe the following. I would like to have a code with Private Sub CommandButton1_Click()
I have an Excel file with a lot of formulas and protected cells.
All I want is to save a copy of Excel file as "Values & Number formatting" Only in Desktop under a specific cell Name from Cells H4, H5 & D4.
Thank you very much in advance!!
PS: Please give me a code in this Format.
Private Sub CommandButton1_Click()
End Sub

Thanks
I am completely new to VBA and Macros. All i know now is to insert ActiveXcontrols and enter the code.
Please help me withe the following. I would like to have a code with Private Sub CommandButton1_Click()
I have an Excel file with a lot of formulas and protected cells.
All I want is to save a copy of Excel file as "Values & Number formatting" Only in Desktop under a specific cell Name from Cells H4, H5 & D4.
Thank you very much in advance!!
PS: Please give me a code in this Format.
Private Sub CommandButton1_Click()
End Sub

Thanks
