philfer
01-01-2008, 12:39 PM
I have a sheet in a workbook called "Menu" where all the buttons sit for the user to perform the tasks they need.
When I put a button there and choose view code it opens the code window behind the worksheet "Menu" I have been putting all my code there
All the Excel VBA books I have read say the code should go in Modules.
Am I committing a cardinal sin? Will I burn in the eternal fires on VBA hell.
If I have to put all the code in a Module how can I get the buttons on the Menu sheet to look at the module rather than the code behind the sheet
When I put a button there and choose view code it opens the code window behind the worksheet "Menu" I have been putting all my code there
All the Excel VBA books I have read say the code should go in Modules.
Am I committing a cardinal sin? Will I burn in the eternal fires on VBA hell.
If I have to put all the code in a Module how can I get the buttons on the Menu sheet to look at the module rather than the code behind the sheet