Forum

How to make a butto...
 
Notifications
Clear all

How to make a button run a macro throughout an entire Excel Workbook

4 Posts
2 Users
0 Reactions
60 Views
(@kahens)
Posts: 2
New Member
Topic starter
 

Hi, I have an excel file that has a summary page.  I want to be able to place a button in the summary page with VBA associated with that button.  However, I would like the button to run on all of the pages in the workbook and not just the sheet the button sits on.  Does anyone know how to do this?

 
Posted : 06/06/2019 4:55 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Kayla,

Do you mean you want the button to appear on all pages, or for whatever code it executes to act on all pages?

Always best to supply your workbook so we have the full picture of your issue.

Regards

Phil

 
Posted : 06/06/2019 5:44 pm
(@kahens)
Posts: 2
New Member
Topic starter
 

I want the code to execute to act on all pages.

 
Posted : 07/06/2019 4:24 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

without seeing your code I can't do anything

 
Posted : 07/06/2019 6:47 pm
Share: