 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2004unexisted macro
Hello experts... This has been driving me crasy!! I have this excel file which runs fine for the past few years on excel 97. It had no problem at all until I upgraded my office to 2003. Now, every time I open this file, there is a warning saying that this file contains macro and bla bla bla..... Of course I can set the security level to low to get away from this.. however, the thing is that I have never created a macro for this file.. and in fact, when I go into tools->macro->macro, there is no macro here. So what is this "hidden" macro that the warning message is warning about? does anyone have any idea? any way to get rid of it? Thanks Fenton Hi see: http://www.contextures.com/xlfaqMac.html#NoMacros  Signature-- Regards Frank Kabel Frankfurt, Germany > Hello experts... > [quoted text clipped - 11 lines] > Thanks > Fenton Wow... it works!!!! thanks This is what I found on every sheet: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) End Sub I deleted them and the marco warning message is gone! By the way, what does that code do? What was it there is the first place? Fenton > Hi > see: [quoted text clipped - 28 lines] > > Thanks > > Fenton Hi this code does nothing. Just the (empty) stub of an event procedure Signature-- Regards Frank Kabel Frankfurt, Germany > Wow... it works!!!! thanks > This is what I found on every sheet: [quoted text clipped - 39 lines] > > > Thanks > > > Fenton But this is where you'd put some code that would fire whenever you changed the selection on that worksheet. Try this against a test worksheet in a test workbook. (rightclick on the worksheet tab and select view code. Then paste this into the code window: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) msgbox target.address End Sub You'll see a message box each time you select a different range. > Wow... it works!!!! thanks > This is what I found on every sheet: [quoted text clipped - 39 lines] > > > Thanks > > > Fenton SignatureDave Peterson ec35720@msn.com |
Reply to this Message |
 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.