Make the same VBA code work for all sheets of the Workbook.

[Francisco Sousa]

Hello,

I have a code that's works on one the sheet1, and I want that same code (vba) to works the same way for all sheets, otherwise I have to copy separately the code for each sheet (sheet2, sheet3... sheet12 and so on) and that requerys a lot of the same code on the Worksheets and time, is that possible?. I think everything is possible to do in VBA for the gurus experts like that the have in Excel F?rum.

The sheet have a six columns, one with automatic calendar that triggers in a cell in the column A, and another five columns for values, sums and the total.

Budget.JPG

Any help will be greatly appreciated.

Regard's
FS

[shg]

Move the code to the ThisWorkbook module in the Workbook_SheetChange or Workbook_SheetSelectionChange event as appropriate.

[Francisco Sousa]

Hello,

Thanks for the suggestion, but can you please give me an example?

Best regards.
FS

[shg]

Please Login or Register  to view this content.

[Francisco Sousa]

Hello again,

I'am sorry for the inconvenience.
I made your suggestion, and the "Calendar1" give the error "Run time Error 424: Object required", can you help me to solve that, I would be very grateful.

Best regards
FS

[shg]

I don't have the calendar control on my system (and it was deprecated in Excel 2007). But it's an ActiveX control, which means that when used on a worksheet (as opposed to on a userform), you're stuck having the event handlers in the worksheet code module.

There are third-party versions that use small userforms that look like the calendar control that may work for you; their events are processed in the form's code module, and so only need to appear once. Google excel alternative calendar control. I have not used any of them, so can't make a recommendation.