ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macros not running (https://www.excelbanter.com/excel-programming/318875-macros-not-running.html)

StephanieH

Macros not running
 
I have several macros that were running fine on Friday, but not working today.
I have a button tied to a macro that simply shows a Userform. When the
Userform opens, I'm fine until I go to make a selection. As soon as the
mouse hovers over the userform, the Debugger comes up and highlights
Userform1.Show.

I don't understand why they would all suddenly stop working....

Ron de Bruin

Macros not running
 
Hi StephanieH

If it only one file that have this problem then Reboot first and :

StartRun
Type: %temp%

Clear all files in this Temp folder and also the sub folders









--
Regards Ron de Bruin
http://www.rondebruin.nl


"StephanieH" wrote in message ...
I have several macros that were running fine on Friday, but not working today.
I have a button tied to a macro that simply shows a Userform. When the
Userform opens, I'm fine until I go to make a selection. As soon as the
mouse hovers over the userform, the Debugger comes up and highlights
Userform1.Show.

I don't understand why they would all suddenly stop working....




StephanieH

Macros not running
 
Yay! Works great again.

Thanks Ron.



"Ron de Bruin" wrote:

Hi StephanieH

If it only one file that have this problem then Reboot first and :

StartRun
Type: %temp%

Clear all files in this Temp folder and also the sub folders









--
Regards Ron de Bruin
http://www.rondebruin.nl


"StephanieH" wrote in message ...
I have several macros that were running fine on Friday, but not working today.
I have a button tied to a macro that simply shows a Userform. When the
Userform opens, I'm fine until I go to make a selection. As soon as the
mouse hovers over the userform, the Debugger comes up and highlights
Userform1.Show.

I don't understand why they would all suddenly stop working....






All times are GMT +1. The time now is 02:51 PM.

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