ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Lost VBA (https://www.excelbanter.com/excel-programming/436325-lost-vba.html)

Otto Moehrbach[_2_]

Lost VBA
 
Excel 2007, Win 7 64-bit
Something disconcerting just happened to me. I have 2 workbooks open, each
of which has several buttons with macros assigned. I've been using one of
these workbooks for about 20 years.
Suddenly, none of the buttons, none of them, fired a macro.
I closed both files and reopened them. All worked fine.
What happened? Thanks for your time. Otto


Don Guillett

Lost VBA
 
Perhaps you were involved in some procedure (copy??) that precluded a macro
firing??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Otto Moehrbach" wrote in message
...
Excel 2007, Win 7 64-bit
Something disconcerting just happened to me. I have 2 workbooks open,
each of which has several buttons with macros assigned. I've been using
one of these workbooks for about 20 years.
Suddenly, none of the buttons, none of them, fired a macro.
I closed both files and reopened them. All worked fine.
What happened? Thanks for your time. Otto



Otto Moehrbach[_2_]

Lost VBA
 
I want to add that there was no VBA error hanging. I know that that will
stop all VBA actions. Otto

"Otto Moehrbach" wrote in message
...
Excel 2007, Win 7 64-bit
Something disconcerting just happened to me. I have 2 workbooks open,
each of which has several buttons with macros assigned. I've been using
one of these workbooks for about 20 years.
Suddenly, none of the buttons, none of them, fired a macro.
I closed both files and reopened them. All worked fine.
What happened? Thanks for your time. Otto



Otto Moehrbach[_2_]

Lost VBA
 
Don
That's all I can think of. I don't know what but it had to be like
that. Thanks. Otto

"Don Guillett" wrote in message
...
Perhaps you were involved in some procedure (copy??) that precluded a
macro firing??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Otto Moehrbach" wrote in message
...
Excel 2007, Win 7 64-bit
Something disconcerting just happened to me. I have 2 workbooks open,
each of which has several buttons with macros assigned. I've been using
one of these workbooks for about 20 years.
Suddenly, none of the buttons, none of them, fired a macro.
I closed both files and reopened them. All worked fine.
What happened? Thanks for your time. Otto




All times are GMT +1. The time now is 03:21 AM.

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