HelpShaneExcel
New Member
Hi all! I'm pretty new to VBA and pretty much just started diving in to this stuff very recently. (We're in need of some major overhauls on our workbooks here at work so I figured why not start learning this stuff)
So how do we set up codes that apply to an entire workbook? By putting them into 'modules'?
If we create a VBA Macro that we want to apply to every worksheet throughout the workbook, is there a way to make all the sheets behave according to the code automatically throughout the workbook? Or do we have to assign the macro (module?) to each existing worksheet individually?
Does it go under 'modules', or does code get copied into the right-click 'view code' on each worksheet tab. I'm really lost with these basic things and think that it is stumping me from progressing in my ability to code.
So how do we set up codes that apply to an entire workbook? By putting them into 'modules'?
If we create a VBA Macro that we want to apply to every worksheet throughout the workbook, is there a way to make all the sheets behave according to the code automatically throughout the workbook? Or do we have to assign the macro (module?) to each existing worksheet individually?
Does it go under 'modules', or does code get copied into the right-click 'view code' on each worksheet tab. I'm really lost with these basic things and think that it is stumping me from progressing in my ability to code.