Clear Filters on Exit

**beegeeblueboy** · 02-25-2010, 09:55 AM

Pretty new on VBA. Seems to be differnt syntax for declaring variables on Private function compared with Public.

I have this macro which clears and switches off a specific filter in a specific sheet but because I want to to run on File/Exit I need to make it a Private function in This Workbook, but the syntax fail. Ideally I would like to clear and switch off all filtering in all worksheets.

I'm sure it is very simple so if yu could supply the code it would be great and also perhaps link to the best explaination for the line one syntax for the Private function.

Many thanks

Please Login or Register  to view this content.

**romperstomper** · 02-25-2010, 10:21 AM

There's no syntactical difference between Private and Public functions - the only difference is where you can call them from.
What you want is basically:

Please Login or Register  to view this content.

**beegeeblueboy** · 02-25-2010, 12:27 PM

Originally Posted by romperstomper

There's no syntactical difference between Private and Public functions - the only difference is where you can call them from.
What you want is basically:

Please Login or Register  to view this content.

Thanks very much. I'm learning all the time. Realised I had get this line in at the beginning

Please Login or Register  to view this content.

.

So everything in This Workbook is invoked when the workbook is opend and closed?

**romperstomper** · 02-25-2010, 12:38 PM

Originally Posted by beegeeblueboy

So everything in This Workbook is invoked when the workbook is opend and closed?

Not exactly - the ThisWorkbook module is where you put code to react to the various events that the workbook exposes - Open, BeforeClose, BeforeSave, BeforePrint etc. You use those events to have code run automatically whenever the user does certain things to the workbook.