Disabling Scrolling

[sighlent1]

Hey,

I was looking around on different sites to see how to "disable"/control the scrolling abilities and i found this code

Please Login or Register  to view this content.

I used it once before and it worked perfectly. I had to edit my excel sheets, now that I'm done, i put this code back in the VBA module and it's not working

I'm not sure if I'm putting the code in the module correctly. Could somebody please help me?

Thank you for your time
Bob

[dominicb]

Good evening sighlent1

I'm not sure if I'm putting the code in the module correctly.

That sounds like a likely cause. Which module have you put it in?
It should be in the Sheet1 module, not a regular macro module.

HTH

DominicB

[JBeaucaire]

It's not working because you didn't install it anywhere, at least I couldn't find it in any of your sheet modules.

I added it INTO the Sheet1 module, and changed the code to:

Please Login or Register  to view this content.

You can install this into any other sheet as is and it would work the same, and it must go INTO the sheet module.

I also trimmed down your other macros, removed all the "selecting" and simply addressed the commands directly to the cells in question. For example:

Please Login or Register  to view this content.

You had separate CLEAR_FIELDS macros for 3 different sheets that all did the same thing. No need for that, so I made one macro and attached the button in each sheet to the same macro.

Take a look.