Posts by xl_spec

    Hi FWind.....


    sorry....but the code actually threw up an error when I ran it in the actual XL File. It worked perfectly in the experimental files i had created......


    when I run this code in the actual Excel File (that incidentally contains more than 800 Macros) I get a "Compile Error....Cant find Project or Library" on the wn.close line....


    As far as my knowledge goes this error relates to something like "Microsoft Excel Object Library" and MS Office OL" not being ticked in the References menu in macros


    But believe me both are ticked and the code works on other XL files but not this.....


    now where it is getting botched up?????


    pl guide me....


    again a million thanx

    Hi guys


    Obviously all must b aware that in an XL File New windows can b created by clicking on "window"Menu and then selecting "New Window".


    I created som windows for a very important office file and now I want to remove the same. However I just havent been able to figure out how to remove / disable a window permanently. I am aware that these windows can be hidden but still I would like to know how to remove them permanently.


    Can someone pl guide me as to how to remove a window? Is there any macro for it????? any guidance would be immensely appreciated


    thanx


    ciao