Hello everybody, I open a workbook and am prompted to enable or disable a macro. However when I look where the macros are located, I do not see a macro to run. How can I either delete the macro or stop the notice from appearing? Any help would be greatly appreciated.
This will delete all the code from the active workbook:
Please Login or Register to view this content.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I copied your code and for some reason it causes the workbook I am working with to not respond. Am I doing something wrong? I am not that familiar with the visual basic editor portion of excel. Again any help would be greatly appreciated.
Did you do this?
Please Login or Register to view this content.
Dom
Please Login or Register to view this content.
Thank you. I guess I didn't see that part. Everything is fine now. Thanks.
Thanks. that really helped.
The probable cause would be an empty module. Even without code this would force the prompt
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks