Making a worksheet macro work for whole workbook

Hi Guys -

I have written a small macro in the worksheet code which just hides some rows in the spreadsheet depending on what's selected in cell B10. But I've just realised that there can be many worksheets in the workbook, and don't want to copy and paste this again for each one. Could i move this code to the workbook and how would I change it?

Thanks!!

John

Please Login or Register  to view this content.

Pop this on the ThisWorkbook code page:

Please Login or Register  to view this content.

Dom