Convert vba to affect different sheet

[Throughstream]

Hi for the life of me I can't work out how to change a macro button to affect another sheet.

I have this basic code, which works great.

Please Login or Register  to view this content.

I want to change it so the button is on Sheet1 and it does the "hide rows" on Sheet19.

Cheers

[BadlySpelledBuoy]

Try this:

Please Login or Register  to view this content.

Or you could use:

Please Login or Register  to view this content.

BSB

[Throughstream]

Try this:

Please Login or Register  to view this content.

Or you could use:

Please Login or Register  to view this content.

BSB

Hi the top one came out with "out of range" error but I just changed it to the name of the sheet and that worked. So thank you very much.

[BadlySpelledBuoy]

The error was probably because you don't have a Sheet(19). The number is like a code number for the sheet rather than the literal name of the sheet or anything to do with it's position relative to other sheets.

If you open the VBE on a newly created workbook with multiple sheets you'll see each sheet has two names (top left). One being the 'code' version and the other being the literal.

Glad it's working for you

BSB