Visual Basic code synatx help.?

Question

What Visual Basic 6.0 code is used to stay on one excel worksheet while the code runs on several other worksheets within the workbook? I just need to cut down on possible seizures when other users fire off the macro I created.

Answer 1

HI,

While on macro creation you can select which level you want run that macro.



try and enjoy

Answer 2

Hi,

I dont know where u have written ur macro.

But u open VBA (Alt + F11) or Go to Main Menu->Insert a Module.

Then Insert a procedure

Then within procedure write ur code.

It will be sheet specific. Address ur sheet by its name like Sheet1 or Sheet2. Not general name like ActiveSheet.

Answer 3

Wtf are you talking about?? "seizures"