+ Reply to Thread
Results 1 to 22 of 22

Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal module???

  1. #1
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal module???

    Hi
    This does not appear to be a major problem, I am just wondering if something might be corrupt?
    Also it is an interesting curiosity…. _..

    _..So I have a file , ( which I have uploaded) , that as far as I know I have never added any Charts ( or any of the old type Macro sheet things , - those that are still kept for backward compatibility, ( Hit Ctrl+F11 when in an Excel Spreadsheet to get one of those ). )

    The worksheet count gives the 4 Tabs that I see.
    The Sheets count gives me 5

    I ran this simple code:
    Please Login or Register  to view this content.
    In the first half of the code for the loop for the 4 Worksheets I get exactly the results I expect. – four Worksheets are found, and the names appear as written on the Tabs.


    In the second half code section for the loop of Sheets, In the first loop , it does not appear to select anything, but gives me the name of my first code module “AlanPike”.
    As far as I know that is a normal code module and not one of the old Macro modules: Module “AlanPike” is visible in the VB Editor as one of 10 modules. ( As far as I can remember I added them all in the same way)
    ( Usually the old Macro modules appear as a tab in the worksheet, (when you Hit Ctrl+F11 when in an Excel Spreadsheet ) . Such a macro module is not usually visible in the VB Editor. They appear in the Sheets count and not in the Worksheets count )

    The file is not important , it was an old temporary file I was about to delete when I noticed by chance this strange phenomena, so thought I would investigate in case it revealed anything interesting. I think the file started out as a Personal macro File, which I then copied into a trash folder, where it is now, and I may have used it a few times for nothing important.
    Anyone can spread any light on this weird phenomena?

    Thanks
    Alan
    Attached Files Attached Files
    Last edited by Doc.AElstein; 06-03-2017 at 08:08 AM. Reason: Typos: mixed up the 4 and 5 in Workkbook name and code , wot a Wolly, Sorry
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    I modified your code to print all sheet names and I got this:

    1 Worksheet Tabelle1
    2 Worksheet Tabelle2
    3 Worksheet Tabelle3
    4 Worksheet TempCodes
    1 sheet AlanPike
    2 sheet Tabelle1
    3 sheet Tabelle2
    4 sheet Tabelle3
    5 sheet TempCodes


    For some reason your file thinks there is a sheet called "AlanPike". When I change the name of that generic code module, the output also changes.

    1 Worksheet Tabelle1
    2 Worksheet Tabelle2
    3 Worksheet Tabelle3
    4 Worksheet TempCodes
    1 sheet Jazz
    2 sheet Tabelle1
    3 sheet Tabelle2
    4 sheet Tabelle3
    5 sheet TempCodes

    Looks to me like some kind of corruption with Excel thinking that a code module is a non-worksheet sheet.

    I got nothin' else.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Hi Jeff,
    Thanks for taking a look.

    It is very strange.
    A while back I experimented with Excel 4 macros / Excel 4.0 Macro Sheet ( https://www.excelforum.com/excel-pro...ml#post4440076 ), - maybe something weird found its way into this file as a result… when I think about it the file would have been open then as at the time it was my Personal macro workbook I think, so that was usually always open. _...
    _.. and at that time I was looking at a similar unanswered problem. ( https://www.excelforum.com/excel-pro...w-modules.html ). That was even weirder – all my worksheet code modules and ThisWorkbook code module got duplicated with the codes from them , and the codes vanished from the original worksheets. The codes did not work in those new modules but did work if I copied them back to the modules from which they had seemingly been stolen. ( I eventually found I was not alone with that problem https://stackoverflow.com/questions/...04699#43004699 https://superuser.com/questions/1005...oject-explorer )

    So maybe I have some corruption then if that is your guess as well.

    As I only have Excel for my own private use these thing do not worry me. They understandably do often worry people using Excel professionally. That other problem was in a large file which is one of two main Files of mine. I find the weird extra modules there a convenient place to store text in, or even codes. Actually, it helped with my messy habit of keeping all code versions I do. The file had already been in use a lot with loads of codes in it when the “corruption” occurred, so all my copies of the codes are in those new strange modules. But I only copy the codes I really need back to the module in which they work. So it was a nice corruption to get. It is like having a full attic – I know everything is there to satisfy my messy habit, but it doesn’t clutter my normal working space ,

    This latest corruption looks fun as well. You could play a fun joke with the file giving it to someone asking for a File with a code that relied any form of looping through worksheets. I only noticed the problem this morning as I used the file to check out a quick code I did for an OP to consolidate worksheets. ( But I was kind and only passed him the code and not the corrupt file with code in it )

    I’ll mark the Thread as Solved in a day or two if no one else has any further ideas, and put it down to some corruption..

    _.. Hmm…. …. …. I wonder if corrupt Excel Files are like old Postage Stamps that have a production error in them and become therefore very valuable later.. Lol… I had better manage my attachment in post #1 and remove it.. and of course Jeff, make sure you delete any copy you have .. I don’t want it to corrupt your Excel.
    Alan





    EDIT: I just remembered something else. A while back my default number of worksheets changed from 3 to 4 and I have no idea why or how… maybe that has something to do with it. But, any new File I make just now is well behaved and has no corruption of the sort discussed here in….. – it shows 4 Worksheets and 4 Sheets…
    Last edited by Doc.AElstein; 06-03-2017 at 05:41 PM.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    CodeCleaner appears to fix it.

    Please Login or Register  to view this content.
    Prints

    1 Tabelle1 (Worksheet)
    2 Tabelle2 (Worksheet)
    3 Tabelle3 (Worksheet)
    4 TempCodes (Worksheet)
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    CodeCleaner

    That code prints for me

    1 AlanPike (Module)
    2 Tabelle1 (Worksheet)
    3 Tabelle2 (Worksheet)
    4 Tabelle3 (Worksheet)
    5 TempCodes (Worksheet)

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Google first, like this: CodeCleaner

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Hi,

    Is there any chance the module was created in Excel 5/95 or using Modules.Add in code? Either of those would produce the effect you are seeing, since Excel 5/95 modules are part of the Sheets collection.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  8. #8
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Hi shg,
    Quote Originally Posted by shg View Post
    Google ??
    ( shgKnowsGoogle.JPG http://imgur.com/41NKnbS )
    Quote Originally Posted by shg View Post
    Google first, like this: CodeCleaner
    Lol…
    _... Oh no! - I lost the bet, - I put money on you answering ( again ) “Google is your friend” .. My answer to that was going to be (again) , “That spying thing is no friend of mine” )

    [joke]Or, was it a question from you ? Here you go:
    Google search engine: http://lmgtfy.com/?q=google
    Example: CodeCleaner http://lmgtfy.com/?q=CodeCleaner
    Or
    I was recommended these to reduce the intrusion into, or grasping at, my Privates
    http://lmgtfy.com/?q=ixquick.com http://lmgtfy.com/?q=DuckDuckGo
    [/joke]
    _.____________________________

    But seriously. Of course I did search ..
    But I am getting more and more nervous these days of downloading stuff. There is such an increasing amount of stuff out there, and so much crap to infect my old poorly protected computers. So I am reluctant to download much without any recommendation. –

    _ can you recommend a link you know is safe to get that, and can you be more precise about what you are talking about – any search obviously chucks up loads of stuff, including likely bad things claiming to be which ever product it is that you are talking about? ( Here is one link that I kept getting redirected to http://www.appspro.com/Utilities/CodeCleaner.htm )

    _ Do you think it is likely to do me any harm to keep using such “corrupt” files ?
    ( I was thinking that this current file would be useful to to punish people for the annoying habit of using Sheets instead of Worksheets. Even fairly senior people seem to do that
    Even just now I sway a couple:
    https://excel.tips.net/T003005_Conde..._Into_One.html
    or they add error correcting I think to a code that mixes the two up so might error ??
    https://excel.tips.net/T003898_Creat...g_a_Macro.html
    )

    _._____
    Thanks for taking a look
    Alan
    Last edited by Doc.AElstein; 06-04-2017 at 03:30 PM.

  9. #9
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Hi Don
    Thanks for the reply,
    I was not sure if you were talking about the same thing as I was meaning by “Old Macro Module” and Excel 4 macros/ Excel 4.0 Macro Sheet” ?
    ( https://www.excelforum.com/excel-pro...ml#post4440076 https://www.excelforum.com/excel-pro...ml#post4668803 )

    I am not too clued up on these things. I have never done anything with , or been anywhere near Excel 5/95, - ( I slept through that period .. Lol… )

    But on second read…
    Quote Originally Posted by xlnitwit View Post
    …any chance ….. or using Modules.Add in code? …would produce the effect you are seeing...
    .
    Interesting:
    I had a rethink and another play.

    It would appear that there are four things here in this discussion to consider that contribute to Sheets.Count, not three as I was thinking…. ( *** in total there appears to be 5 documented, and our / your Excel 5/95 module is likely an un documented 6th *** )

    in our discussions We have here these Sheets:
    _1 _ Worksheets.
    _2 _ Charts
    _3 _ (“macro_x tab thing” ( “4 Macro sheet ?? ”) ).
    This is Something that you get when you are in Excel Spreadsheet and hit _ Ctrl+F11 _ . This appears as a tab in the workbook called _ macro1 _ macro2 _ macro3 _ etc. These do not appear in the VB Editor VBAProject explorer Window. You can write codes in those “sheets” as I experimented with : : https://www.excelforum.com/excel-pro...ml#post4440076 _..... I think I had a slight error in thinking in that Post. I think now that there is no Macro 4 module.
    _.................

    A module that appears in Sheets .Count but not in Worksheets .Count is, as you said, .. “…… Excel 5/95 module….since Excel 5/95 modules are part of the Sheets collection………”
    So: we have also:-
    _4 _ ( “Excel 5/95 modules“ ??). - You can get, as you rightly say, a code module that does appear in the VB Editor VBAProject explorer Window using a code line _ Modules.Add . This looks like a normal code module , and indeed works like a normal code module. You can also delete it with _ Modules.Delete . This also , like _3 _ contributes to Sheets count but not to worksheets count.

    I mistakenly thought the last two were the same. I expect most people that have encountered the “ Worksheets / Sheets .Count discrepancy “ may have also thought that.

    So you are correct that _4 _ could explain my File.
    It does. I tried it . - To explain
    I can do this in a code:
    Modules.Add
    Modules.Delete

    Or
    Modules.Add
    Modules.Add
    Modules.Delete
    Modules.Delete

    Etc…..
    In the following code the last code line errors
    Modules.Add
    Modules.Add
    Modules.Delete
    Modules.Delete
    Modules.Delete

    So I the point is that I can Delete as many times as I have Added

    So in my mysterious file , I would expect that I could do
    Modules.Delete
    once , and that the module “AlanPike” would vanish.
    It does!

    So that is likely the problem: I may well in the past in some experimenting have done one more _ Modules.Add _ than I did _ Modules.Delete s

    It might be a bit debateable whether the Code Cleaning thing that shg tried should delete such modules or not: The conclusion here is that my file possibly is not corrupt. I guess it would be worth a try to do a Modules.Add and then run the Code Cleaning thing after to see what happens. Also it would be interesting to see if I Added a “macro_x tab thing” thing ( 4 Macro sheet ?? ) ) , and then run the Code Cleaning thing after to see what happens.

    I expect we almost have this Solved. I will probably mark as such soon. It looks like it is getting sussed….

    Thanks again
    Alan


    P.S: A summarising code for Posterity here:
    https://www.excelforum.com/developme...ml#post4669212
    P.S. 2: I did Google https://msdn.microsoft.com/en-us/lib.../ff839847.aspx *** https://msdn.microsoft.com/en-us/lib.../ff838774.aspx *** .. and experimented further: …
    _.. An Excel 4 Macro Sheet is according to Excel a Worksheet Type.
    _.. An Excel 5 / 95 module is a module Type, ( as shg showed also ). It is very difficult to find any documentation on this, and XL 95 books seem not to have much about macros in them… and I got some pretty weird results so I did not experiment too far.. .
    A few things I did find:
    _.. An Added module seems to take the sheet index ( item number ) of that of the last, so it shifts the current last Sheet’s index ( item number ) up by one. ..
    _..It appears it has no Code Name. It can be given a Name. But then you can get some weird results and some bad Excel crashes when you try to delete them by name or manually…
    _... Once named a single Modules.Delete is all you need to delete them all _…. All a bit messy with no documentation.., so I wont take this much further, I think we have the mystery Solved
    https://www.excelforum.com/developme...ml#post4669212
    Last edited by Doc.AElstein; 06-04-2017 at 10:18 AM.

  10. #10
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Code Cleaner in essence exports all modules, removes them and reimports them. That would naturally replace any Excel 95 modules with newer modules.

    By the way, I think you perhaps clicked the wrong button again when repping me.

  11. #11
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Hi
    Quote Originally Posted by xlnitwit View Post
    Code Cleaner in essence exports all modules, removes them and re imports .. would naturally replace any Excel 95 modules with newer modules...
    I suppose it might be dangerous to use the Excel 95 modules rather than normal modules, .. but I might just use them for a while instead and see what happens..

    Quote Originally Posted by xlnitwit View Post
    .. I think clicked the wrong button again when repping me.
    Hmm, - Wot a twit I am. Sorry. - I have asked Admin to change it, - they usually can and do when asked..

    Alan

    P.s. Edit
    Quote Originally Posted by Doc.AElstein View Post
    ...might be a bit debateable whether the Code Cleaning thing that shg tried should delete such modules or not: .....
    I see from what yoou are saying that they are not deleted... they are "converted" into normal modues
    Last edited by Doc.AElstein; 06-04-2017 at 02:32 PM.

  12. #12
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    No, they are deleted. All modules are removed and the code is then reimported as a new module. That is what converts them.

  13. #13
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    I think I agree, - I just explained myself badly.
    What I really meant to say was that the code is not lost. - ( I think I read somewhere that the code text is taken and put into a new module..)

    I can’t be 100% sure as I don’t have a code cleaner. What shg demoed showed that there was no longer the ( presumably Excel 5 / 95 ) module after the clean.
    But I assume however, that after the clean a new normal module ( that would not appear in the Sheets .Count ) is there with the code in it from the deleted ( presumably Excel 5 / 95 ) module, and presumably that new module has the name of the deleted ( presumably Excel 5 / 95 ) module.

  14. #14
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    CodeCleaner exports the modules as .bas and .cls files, saves the workbook as an temporary xlsx file, closes that file so the code is well and truly gone, reopens the file, imports the code back, and if everything is good, writes over the old xlsm file.
    Last edited by shg; 06-04-2017 at 05:50 PM.

  15. #15
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Thanks shg. I guess that is saying something similar to the lines of what I was thinking.
    Sounds like it is attempting to take the minimum or exact “data” necessary to “build” a new module.
    It takes that data from the existing modules. I guess someone has thought about this and decided that was for what ever reasons the best way to do it. I am guessing it is done in the particular way that it is done to make it universal for all module types including Class types. Hence you have a file .bas which is probably very close to a simple text file of the code, and a .cls which is something a bit more subtle including the Class / Blueprint information so that you can construct the “form” of the module
    ( I ixquick’ed ( ixquick- un spying google ) :-) )

    _._______________________________________________

    I think I would like to wrap this and a few similar unanswered threads by confirming that Code Cleaner “rebuilds” correctly all the modules in this particular case, - and it would be very interesting to see how it handles those other unanswered Threads where more significant “corruption” has occurred.
    To that end, can anyone recommend a site / link to download it from that they think is fairly safe/ reliable ?
    Or, assuming it is an Add in, is it possible that someone could drop me off a file copy so as to avoid me risking any download ?

    Thanks
    Alan

  16. #16
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    The original source is probably the best location- http://www.appspro.com/Utilities/CodeCleaner.htm

  17. #17
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    OK, thanks, - that was the one I most often was linked to from other places - I will give it a go.
    Alan

  18. #18
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    So I downloaded it from http://www.appspro.com/Utilities/CodeCleaner.htm
    Opened it, allowed it to continue when the Administrator warning Window came up
    Went through a set of “Wizzard Window” things that came up ( I changed the paths for the thing to go to an external Folder ..
    After the download was complete I ended up with this:
    CodeCleanerDownloadInFolder.JPG http://imgur.com/FBCKyd2
    I double clicked on UNWISE.EXE
    Allowed it to continue when the Administrator warning Window came up
    That took me to an uninstall Wizzard , so that was no good

    Then I reread the info at the link ( http://www.appspro.com/Utilities/CodeCleaner.htm ) “…..The Code Cleaner creates a 'Clean Project' menu item below the Tools menu in the Visual Basic Editor. Click this menu item to run the code cleaner….”
    ( The following I have doone before to get other stuff to work ages ago: Excel 2007 - Choose Office Button > Excel Options > Trust Center > Trust Center Settings > Macro Settings. Check the checkbox labeled Trust Access to Visual Basic Project and click OK twice to finish. )
    Nothing there that I can see???

    Restarted Excel…. There you go: :-) :-
    ThereYouGoMateyGotCodeCleaner.JPG http://imgur.com/XFWNscc

    It would appear that you need to have the file open that you want to “clean”.
    So I open the fille
    ReadyToCleanMatey.JPG http://imgur.com/u4Tan7L
    Click OK

    It completes very quick.
    After I run the various codes discussed in this Thread, and confirm I now have 4 Worksheets and 4 Sheets.
    But Importantly the module (“AlanPike”) that was apparently a Excel 5/95 module is still there with the same name , but presumably a normal code module now.
    CodeCleanerThing_MateyGotYaClean.JPG http://imgur.com/SnE6U7J

    The code in that new normal module appears to be OK at first glance
    All is well
    This Thread is Solved ( Original File, “cleaned”, resaved and uploaded : Wb_with_5Sheets_4WorksheetsWellActually_4SheetsNowMateyAfterCodeCleaner.xlsm )
    Thanks everyone

    _.............
    _._____________________

    I thought while I am at it I would try the File from a few other unsolved Threads, such as this one of mine: (Problem Weirdo 2) https://www.excelforum.com/excel-pro...w-modules.html
    It does nothing to that one. Never mind.. I’ve grown to love that file as it is, - with its extra ThisWorkbook and Worksheet Code Modules Mutations,
    - its special :-)

    Alan
    Last edited by Doc.AElstein; 06-05-2017 at 05:01 AM. Reason: Forgot the File ... well its not too important Matey

  19. #19
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Quote Originally Posted by Doc.AElstein View Post
    Hmm, - Wot a twit I am. Sorry. - I have asked Admin to change it, - they usually can and do when asked..

    Alan
    neg rep reversed
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  20. #20
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Thank you both- most kind.

  21. #21
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Next time, just slap him lol

  22. #22
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Extra Sheet not a Chart or Old Macro Module or Worksheet - Appears to be normal modul

    Hi Don, Hi Ford
    Thanks, Ford - I don’t think it did Don too much harm, - I expect not many get a reputation beyond repute before reaching Forum Expert Status…..
    I guess according, to the Rules .. ( https://www.excelforum.com/forum-rul...rum-rules.html - Forum Expert: 360 days registered, 1200 posts and 600 reputation points. ) … he will achieve that great career height in about 3 weeks and will be bestowed the great Honour at his first Anniversary Party on 27Th June this year. ( I drink Dunkle Beer BTW in case I am invited to the party, ).
    DonANitWitWithoutRepute.JPG http://imgur.com/RQa2Eiw
    _....
    Slap away… I need it …
    I could probably do with a good beating , to have some sense knocked into me, I have probably missed a few slaps in recent years. I miss the more direct and strong approach here in this idyllic neck of the Bavarian Hills…

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Code locks cells when inserted in sheet module but returns error in standard module
    By yoda66 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2014, 07:39 AM
  2. how to access Sheet module, normal module, Worbook module to type code
    By alibaba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2009, 07:51 AM
  3. Replies: 2
    Last Post: 03-27-2009, 11:48 AM
  4. Can you run a macro on a worksheet from a module in an XLA?
    By Trefor in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-19-2006, 04:20 AM
  5. [SOLVED] Calling worksheet module from other module.
    By Michael Malinsky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2005, 04:50 PM
  6. Run worksheet module code from workbook module?
    By keithb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2005, 12:05 AM
  7. [SOLVED] Calls from sheet module to ThisWorkbook module
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2005, 11:05 AM
  8. [SOLVED] Calling an embedded items event procedure from within a normal module
    By jase in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1