Routine no longer working in Excel Module?

Hi everyone, I'm a relative newbie to VBA within Office Apps, A work collegue and I wrote a program in VB6 that enabled us to use "right Click" context menus in Excel 2003, basically when you clicked on one of the menus it ran a Sub which was held in a sheet called personal.xls which is in the XLSTART folder on the pc. For some reason it's now not working at all on my pc although it's working on several other pc's, I've opened up the sheet I'm working on in the Visual Basic Editor and the the personal.xls sheet is there along with my other workbook, I've put a breakpoint on the sub in question, gone back to the orginal sheet and fired up the context menu expecting to find the cursor stuck on the break point, but nothing happens. It's as if the personal.xls isn't part of the sheet, I hope I've explained this correctly. Can someone advise me as to what may be wrong?

thanks for the reply romperstomper, just tried your suggestion but alas it doesn't work still

Hi, yes I've tried restarting Excel, this problem has been going for weeks, the whole pc has been restarted many times, I've 2 pc's on my desk, both with the same software, one works the other doesn't. It's as if Excel dosn't know the personal.xls sheet is there

I've just noticed one thing a bit strange, if I just open up the file I'm using by double clicking it on the first pc, then open up Visual Basic Editor, I see the file personal.xls in the list, if I open it on the other pc (same file) and look in the visual basic editor, it isn't in the list, is this of any help?

My thoughts exactly, but I've check and the setup is identical on both pc's, I've even copied the working personal.xls from the working pc to the other one, still no luck... by the way, thanks for your patience

I've just looked in the options within Excel looked at the General Tap, the default file loacation is the same on both pc's

that's exactly where the file is

yes it is, I've doubled checked, even reinstalling Excel doesn't help

I've even searched through the registry, looking for any reference to XLSTART or personal, making sure all the entries are the same on both pc's

I did try double clicking my work book, then going to xlstart and double clicking the personal.xls, then it appears in the vb editor list but the right click menu still doesn't work

yes it loads in pc2 but doesn't in pc1

looks like you on the right track !!, Personal.xls was listed under disabled items, I've re enabled it and now personal.xls opens when I close excel and then open my file, but the right context menu still isn't running anything on the module

unfortunatly, I didn't write the vb6 code, but looking at my collegues coding it looks like it modifies the commandbar

if you understand VB I can always attach a text file with the code on, if it's any help. but to be honest the problem must lie with Excel itself as all the workbooks /sheets are identical, and the vb code is exactly the same on all pc's, it just appears that someting has been modified in Excel to stop it working correctly

the OnAction command

hope this helps

all machines are set on low security, I know this is a risk. I've checked the offending pc and the setting is still low

before I do that, I've just found something peculiar, I've just droped another file with macro's in the same xlstart directory and they work, it's just anything on the personal.xls file they don't

no, none at all

yes, the same file is given out to all machines, I've even copied over personal.xls from a working pc, I've checked and it's not in the disabled list. Something in Excel is stopping the personal.xls from working properly, I'm really gratfull for all the time you've put into this, my only course of action is as before and thats to do a rebuild of the whole pc, it would have just been nice to find out the cause. Many thanks again

I've just rebooted the pc, and guess what !!!! it's working, I don't know what it is you've got me to do, but something must have worked !!! I just wish I knew what it was !

Thank you so much for all your time and effort