Graham C1600
Board Regular
- Joined
- Feb 17, 2018
- Messages
- 96
- Office Version
- 365
Ok so here goes.
I have a spreadsheet where I need to calculate various things and then finally need to do the following :-
I will put a Form Control Button on the worksheet and then hopefully just put the code onto this button.
Hope this makes sense.
I have a spreadsheet where I need to calculate various things and then finally need to do the following :-
- Create a copy of the worksheet in a new book.
- Rename the worksheet based on Cells A2 & A3 (these are only names)
- Save the worksheet to my desktop and name it as per cells A2 & A3.
- Put a password on to open the spreadsheet 'Password 123'. I can change this at a later date.
I will put a Form Control Button on the worksheet and then hopefully just put the code onto this button.
Hope this makes sense.