Excel Macro - Filter button activate on both sheet if activated on one sheet

Hi All,

I have a workbook that has 2 worksheets. I have filter button (macro based) that I have created on both sheets.

I would like to link these two filter buttons so that if I activate this filter button on one sheet then it automatically activates the filter button on the other sheet.

Regards

Hi umeshbanga,

If you have the following Macros associated with the buttons:
a. First Sheet - MacroA
b. Second Sheet - MacroB

My first attempt would be to replace the existing Macros with new Macros:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Lewis

I have tried this does not work.

My existing macro is below. Are you suggesting in the module I create the above. I have tried but does not work. My other macro is same just for the other sheet and other button. Hope this makes sense.

Please Login or Register  to view this content.

Sorry it didn't work. Since your code is sheet specific (i.e. ActiveSheet), both macros probably process the same Sheet. In order to solve your problem, you're going to have to upload a sample workbook that contains at a minimum the two sheets and their macros. There doesn't have to be any data in the workbook, and make sure you delete any proprietary information.

To upload a sample workbook:
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic

Lewis

Here it is.

Call the other onclick event and make it true when the other is true... should work if you cant figure it out I will post the answer

I cant figure it out.

Can you not just do something like this in each of the sections instead of calling the entire onclick event...
This would go in the True Click of Detailed Notes Onclick Event...

Please Login or Register  to view this content.

Hi umeshbanga,

Since I only have access to Excel 2003, and some of your commands are not supported by Excel 2003, I had a little bit of trouble. Instead of using your workbook, I made a skeleton copy of your workbook and simulated what you wanted in the attached file.

The code is supposed to work as follows:
a. User Clicks an 'Active X Control'.
b. The normal Event Handler for that control gets activated (e.g. ActiveItemFilterCheckbox_Click().
c. The normal Event Handler calls Sub ProcessSynchronizedUpdateRequest() which reads the list of routines to be activated (from Sheet 'Settings'). Each routine is activated in turn, EXCEPT the original routine which is only activated once (when originally clicked by the user).


My data entries and code to implement my solution are as follows:
a. In Sheet 'Settings' a list of Sheets and Macro names to be synchronized is REQUIRED. For example:

Please Login or Register  to view this content.

b. A processing macro is required in an ordinary code module such as 'Module1':

Please Login or Register  to view this content.

c. Code has to be added to Event Handler Macros like in the following:
Sheet 'ProjectandBAU' module:

Please Login or Register  to view this content.

Sheet 'SheetX' module:

Please Login or Register  to view this content.

Lewis