lordterrin
Board Regular
- Joined
- Mar 21, 2012
- Messages
- 155
I have no idea what happened to my workbook.
I have been writing it for about two weeks, and all of the sudden when I load it now I cannot execute any macros using button clicks. (I have several buttons linked to execute macros.)
I can still run them by going to Macros --> View Macros.
When I load up the file, I no longer get the prompt that asks me whether or not I want to enable macros. I've checked the security settings in Developer --> Macro Security and I don't think anything has changed here. It's set to disable with notification.
This destroys my entire sheet and makes it unusable, so I would LOVE to understand what happened and why this is all screwed up. The file is not password protected.
I can send the file to someone in a PM if it helps analyze it.
The last thing I did on my file was try to add a splash screen using the file "simplesplash.zip" from this website:
Message box to pop-up at file open
It worked, until I saved the workbook, closed Excel, and reopened. This is when all of my macros stopped working from button clicks.
Thank you so much!
I have been writing it for about two weeks, and all of the sudden when I load it now I cannot execute any macros using button clicks. (I have several buttons linked to execute macros.)
I can still run them by going to Macros --> View Macros.
When I load up the file, I no longer get the prompt that asks me whether or not I want to enable macros. I've checked the security settings in Developer --> Macro Security and I don't think anything has changed here. It's set to disable with notification.
This destroys my entire sheet and makes it unusable, so I would LOVE to understand what happened and why this is all screwed up. The file is not password protected.
I can send the file to someone in a PM if it helps analyze it.
The last thing I did on my file was try to add a splash screen using the file "simplesplash.zip" from this website:
Message box to pop-up at file open
It worked, until I saved the workbook, closed Excel, and reopened. This is when all of my macros stopped working from button clicks.
Thank you so much!