Variables, Macros and Command Buttons?

[samsonjonesuk]

Hi everyone

I have a master spreadsheet containing some hefty macros (10 in all), some are relatively large macros (for me anyway) with around 1000 lines and quite a lot of processing power.

Anyway, in ordr to simplify this to the people who will be running the processes I am trying to create a master control worksheet containing Command Buttons.

All they need to do is click the button and follow the instructions - simple.

However I am not a macro expert never mind a Command Button expert and my first noob problem is:-

If I assign the macro code to each command button call 1 - 10, will all of the code form one monster macro and hence create performance problems.

Following my answer to this I will decide whether to embarrass myself further.

Thanks

Sean

 

[boxsterman]

No, each macro will remain independant of each other.

 

[samsonjonesuk]

Thanks for the swift response.

To my next question then, each macro has a number of public variables, will these still work using command buttons to process them or do i need to make them private or something?

Sorry for my noobness.

Sean