Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / September 2004

Tip: Looking for answers? Try searching our database.

macro enable/disable message

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
grace - 23 Sep 2004 18:48 GMT
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 - 23 Sep 2004 19:29 GMT
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.

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> Hello,
> I have a spreadsheet that does not contain any macros.
[quoted text clipped - 4 lines]
> thank you,
> Grace
ibanker99 - 27 Sep 2004 18:33 GMT
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?

> Grace
>
[quoted text clipped - 19 lines]
> > thank you,
> > Grace
Nick Hodge - 28 Sep 2004 00:30 GMT
Grace

Email me the file and I'll clean it

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> Nick -
>
[quoted text clipped - 48 lines]
>> > thank you,
>> > Grace

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.