Replies

I’m baaaack!

Well, it’s a new day, I have a new install of Office 2003 Pro and the same problem as yesterday.

I followed your (Hans’) suggestion and, with the new installation recording a new macro and saving it to Personal Macro file actually worked, and the new macro
showed up in the macro list and in the VBE. I saved the new Personal.xls file and exited Excel and then opened Win. Explorer and searched for the new file
and it couldn’t be found. When I reopened Excel there was no macro to be found.

I then located the earlier Personal.xls file (the one I want to use, with all my macros in it) and double-clicked it to open it in Excel, and got the “macro warning” dialogbox and chose to make the macros available.
Excel showed nothing whatsoever, no opened file, no title in the title bar, and the Hide/Unhide option on the Windows menu was greyed out. Nothing in the macros list, and Personal.xls was visible in the VBE.

By the way, I do have admin rights (locally) on this machine.

(I’m baffled…)

Dan

Hans,

Appologies for not getting back to you sooner, my pc has been taken over by the IT guys at my company.
They are, on there own independent decision, reinstalling Office.

that may well solve this thing. If it doesn’t I will try your last suggestion and either way I will let you know what happened.
As it is about 15 mins from my departure time from work, it will probably be tomorrow before I can get back to you.

Thanks for your help, so far and , cheers!

Dan

I checked that and, no, it isn’t set to be Read-only.
I also checked if the file was set as Hidden (files in XLSTART are set to Hidden will be open and available each time Excel is started.)
Now it is not set as Hidden and the file is invisible to Excel, but it IS visible to the VBE. When I change it to Hidden it is invisible to both.

Dan

Hi, Hans.

Thanks for your interest. I tried that (new macro stored in Personal Macros WB.)
It did not show up in the macro list, nor in the VBE.

Dan

FWIW I was a single-clicker for a while, but what with that and other tweaks I had made I was becoming less and less able to relate to my coworkers, such that when they ask me for help I’d be lost trying to work on their default MS out-of-the-box pcs!

Anyway, I’ve set up both Hans’ and BigAl’s methods and I’ll try each and see which works best for me.

Thanks, guys!
ps- the ‘cellmate’ moniker is just a ref to our being connected in the cells of Excel (although, the ‘cubicle hell’ bit fits as well!

Sorry for taking so much time to get back to you-all. I lost connectivity for most of yesterday!

I will check out all of these.

Thanks for your help!

Dan

That was a thing of beauty!! Thank you so much.
All that concatenating of the parts of the formula was a little unexpected.
Worked like a charm and I will get a lot of mileage out of this.

Thanks, again,

Dan