Scruffy Space Gardener
New Member
- Joined
- Jan 14, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hi Experts,
I am trying to piece together a VBA code for a command button to:
1) save a copy of a sheet into a new workbook (source sheet currently located in a collaborative workbook which I would like to preserve)
2) save it as a values only copy into a specified folder (take away the formatting)
3) name the new workbook as a combination 3 other cells on the source sheet [a5 & b5 & c5]
I'd greatly appreciate the help.
Thank you!
I am trying to piece together a VBA code for a command button to:
1) save a copy of a sheet into a new workbook (source sheet currently located in a collaborative workbook which I would like to preserve)
2) save it as a values only copy into a specified folder (take away the formatting)
3) name the new workbook as a combination 3 other cells on the source sheet [a5 & b5 & c5]
I'd greatly appreciate the help.
Thank you!