Dear all,
Alright, I have to confess it. I have no idea how to add VB script to a workbook. Everyone talks about it as if it’s a given, but I can’t make heads not tails of the help files on this site.
I have been given a slab of code with the instruction that running it will potentially shrink the size of the workbook file. I have opened up the editor, inserted the aforementioned code into the workbook script window (or what I assume is the workbook script window) and the only change I have noticed is that the file has become larger.
Can anyone either A.) explain what I am doing wrong and tell me how to get this thing to work or B.) point me towards a help site that explains the process in fairly simple terms.
Best,
Max
Alright, I have to confess it. I have no idea how to add VB script to a workbook. Everyone talks about it as if it’s a given, but I can’t make heads not tails of the help files on this site.
I have been given a slab of code with the instruction that running it will potentially shrink the size of the workbook file. I have opened up the editor, inserted the aforementioned code into the workbook script window (or what I assume is the workbook script window) and the only change I have noticed is that the file has become larger.
Can anyone either A.) explain what I am doing wrong and tell me how to get this thing to work or B.) point me towards a help site that explains the process in fairly simple terms.
Best,
Max