ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Remove Macro Message (https://www.excelbanter.com/excel-programming/384823-remove-macro-message.html)

Jordan

Remove Macro Message
 
I was using a Macro that I have now deleted. I also have a button that I am
using to protect and unprotect a sheet.

I was tring to get the Enable Macro button to not show when opening the
file. (I removed Module1 even though it was empty) but the warning is still
there.

Is this because of the button and if not what can I do to get rid of the
warning.

Thanks for any help you can give me.

Bob Flanagan

Remove Macro Message
 
Its 99% likely that the button is the cause. I have seen such trigger macro
warnings.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Jordan" wrote in message
...
I was using a Macro that I have now deleted. I also have a button that I
am
using to protect and unprotect a sheet.

I was tring to get the Enable Macro button to not show when opening the
file. (I removed Module1 even though it was empty) but the warning is
still
there.

Is this because of the button and if not what can I do to get rid of the
warning.

Thanks for any help you can give me.




Dave Peterson

Remove Macro Message
 
Check out Debra Dalgleish's notes:
http://contextures.com/xlfaqMac.html#NoMacros

Jordan wrote:

I was using a Macro that I have now deleted. I also have a button that I am
using to protect and unprotect a sheet.

I was tring to get the Enable Macro button to not show when opening the
file. (I removed Module1 even though it was empty) but the warning is still
there.

Is this because of the button and if not what can I do to get rid of the
warning.

Thanks for any help you can give me.


--

Dave Peterson


All times are GMT +1. The time now is 08:53 AM.

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