Drover's dog
Well-Known Member
- Joined
- 10/1/18
- Messages
- 60
- Reaction score
- 9
Sheer genius...
Hi opercularia I am not at home atm, should be back in a few days and will look at the problem.
Hangover68 the spreadsheet cannot be used in openoffice as the macros will not run.
cheers
Ian
Hi opercularia. Had a chance to look at the recipe deletion problem.The recipes are grouped in sets of 10, it appears not to move recipe 11 to 10 correctly.
To fix the problem you need to get access to the "deleterecipe" macro how to do this depends on the Excel version.
You need to edit the deleterecipe macro, near the end of the macro you will see the following line
Range(ActiveCell.Offset(24, -36), ActiveCell.Offset(39, -34)).Cut Range(ActiveCell, ActiveCell.Offset(23, 2))
The 39 value needs to be changed to 46
Range(ActiveCell.Offset(24, -36), ActiveCell.Offset(46, -34)).Cut Range(ActiveCell, ActiveCell.Offset(23, 2))
then save the spreadsheet.
Hope that fixes trhe problem.
Cheers
Ian
G'day Ian,Hi opercularia I am not at home atm, should be back in a few days and will look at the problem.
Hangover68 the spreadsheet cannot be used in openoffice as the macros will not run.
cheers
Ian
Thanks ianh!No you cannot just change the batch size saved in recipes. When you save recipe it just saves the value thats in the Ferment Volume cell.
Enter your email address to join: