ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Delete key not enabled on macros drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/107259-delete-key-not-enabled-macros-drop-down-list.html)

carol49

Delete key not enabled on macros drop down list
 
I have a worksheet that i created and have never created a macro in it. (I
have never taken the time to learn how.) Yet, there are two macros in the
workbook--probably created during major system problems compounded by inept
tech support. When i select tools-macros and try to delete the macros, the
delete key is not enabled. The macros, which are in a file named Billing, are
named Billing.xls!Module1. Insert and Billing.xls!Module2.OpenFile. When
opening this file, i cannot select other files to open at the same time--they
just dont open. How do i get rid of these macros?
carol

Debra Dalgleish

Delete key not enabled on macros drop down list
 
There are instructions here for deleting the modules:

http://www.contextures.com/xlfaqMac.html#NoMacros

carol49 wrote:
I have a worksheet that i created and have never created a macro in it. (I
have never taken the time to learn how.) Yet, there are two macros in the
workbook--probably created during major system problems compounded by inept
tech support. When i select tools-macros and try to delete the macros, the
delete key is not enabled. The macros, which are in a file named Billing, are
named Billing.xls!Module1. Insert and Billing.xls!Module2.OpenFile. When
opening this file, i cannot select other files to open at the same time--they
just dont open. How do i get rid of these macros?
carol



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


carol49

Delete key not enabled on macros drop down list
 
Thanks Debra..Even i could follow the instructions.!! It worked.
carol

"Debra Dalgleish" wrote:

There are instructions here for deleting the modules:

http://www.contextures.com/xlfaqMac.html#NoMacros

carol49 wrote:
I have a worksheet that i created and have never created a macro in it. (I
have never taken the time to learn how.) Yet, there are two macros in the
workbook--probably created during major system problems compounded by inept
tech support. When i select tools-macros and try to delete the macros, the
delete key is not enabled. The macros, which are in a file named Billing, are
named Billing.xls!Module1. Insert and Billing.xls!Module2.OpenFile. When
opening this file, i cannot select other files to open at the same time--they
just dont open. How do i get rid of these macros?
carol



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



Debra Dalgleish

Delete key not enabled on macros drop down list
 
You're welcome! Thanks for letting me know that it worked.

carol49 wrote:
Thanks Debra..Even i could follow the instructions.!! It worked.
carol

"Debra Dalgleish" wrote:


There are instructions here for deleting the modules:

http://www.contextures.com/xlfaqMac.html#NoMacros

carol49 wrote:

I have a worksheet that i created and have never created a macro in it. (I
have never taken the time to learn how.) Yet, there are two macros in the
workbook--probably created during major system problems compounded by inept
tech support. When i select tools-macros and try to delete the macros, the
delete key is not enabled. The macros, which are in a file named Billing, are
named Billing.xls!Module1. Insert and Billing.xls!Module2.OpenFile. When
opening this file, i cannot select other files to open at the same time--they
just dont open. How do i get rid of these macros?
carol



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



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

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