Are you happy to fix something in VBA yourself? If you would rather not, send me the file (just conscious you were unable to attach previously)
It's straightforward.
One line needs adding back into 2 procedures (this line should have been included when everything combined into one menu).
Sheets("PrintForm").Cells.ClearContents
Paste the above line as the first line of the code (below the line starting with Sub...) ending up exactly as shown below.
How to do it
Hit ALT + F11 (to open VBA)
in LEFT window under MODULES there is one called INDEX
(you may need to double click on MODULES to see its contents)
Double click on INDEX to select it
Then in the RIGHT window,
(which should have about a dozen short procedures, all called something ending in _Click)
- scroll to the bottom, and it is into the last 2 procedures where you need to insert the line
To exit VBA
- right click on the X in top right corner
Now SAVE the file
And TEST it.
Let me know.
EDIT
BEFORE YOU START save the file, and then if anything goes wrong, close without saving. No damage done!
Bookmarks