ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA and Excel 2007 (https://www.excelbanter.com/excel-programming/406580-vba-excel-2007-a.html)

Papa Jonah

VBA and Excel 2007
 
I just loaded Office 2007. I am trying to use Excel files from previous
versions of Excel that have form buttons, and underlying macros. When I
click on the button it just puts the edit border thing around it rather than
run the macro. I can't figure out how to get it to run.
Any help would be much appreciated.
TIA
Papa

Dave Peterson

VBA and Excel 2007
 
I'd try rightclicking on each of the buttons from the forms toolbar and
reassigning the macros.

Papa Jonah wrote:

I just loaded Office 2007. I am trying to use Excel files from previous
versions of Excel that have form buttons, and underlying macros. When I
click on the button it just puts the edit border thing around it rather than
run the macro. I can't figure out how to get it to run.
Any help would be much appreciated.
TIA
Papa


--

Dave Peterson


All times are GMT +1. The time now is 06:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com