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
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
Thanks![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
Thanks
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)