macro enable/disable message

[grace]

Hello,
I have a spreadsheet that does not contain any macros.
However, when you load the spreadsheet, the message
to "enable/disable" the macros displays. Is there any way
to turn the message off?

thank you,
Grace

 

[Nick Hodge]

Grace

Excel displays this message if it 'thinks' it still has code. Open the
file...press Alt+F11 this opens the VBE. In the 'Project Explorer' hunt
down the name of the file. Below this you may see entries such as 'Modulex'
(where x is a number). Right click on any, (if your sure you don't need any
code in them) and select 'Remove modulex'. Answer 'No' in the dialog and
then close the VBE and save the workbook. All should be OK now.

If it isn't then you have userforms set up or have code behind sheets or the
ThisWorkbook module. You can see these in the same 'Project Explorer'.
Just double click on these and delete any code that you find. You do not
need to delete other than this for these modules. Again close the VBE and
save the workbook.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[ibanker99]

Nick -

This is a start for my problem but I need a little more. I recently created
a new excel file and experimented with using a button but quickly gave up and
deleted it. While creating most of the file, I had no problems. However,
the pointer becomes a finger when I insert a formula and try to reference a
cell in another sheet and I am unable from clicking on a cell. I can still
uses the arrow keys to navigate and select a cell but need to remove this
peculiarity.

I have opened the VBE and located the file but saw no 'modulex' to right
click on. The sheets of the problem file are listed and fid the following
code: "Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub"

Although I have selected and deleted said code and resaved the file, it does
not appear to take (eg. the code is still there when I reopen the file).

Thoughts?

 

[Nick Hodge]

Grace

Email me the file and I'll clean it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)