Recent content by sprog1977

My fault. I mean the lines the freeze panes creates. Sorry!

I am trying to change the colour of the freeze panes option but am now wondering if it is at all possible. My boss has asked me this. I know it seems a weird request, but he has gone format mad!!!! I have checked all the logical places, checked what little I know in VB, to no avail. Can...

I am trying to figure out how to get a list of all the table and query names of a given Access database and export or simply copy them into Excel. I looked at FAQ 700-4310 but I couldn't get it to work, plus I am unsure if this was my desired result. The reason for this thread is that I am...

I have a pivot table in excel that is linked to an access query. The problem I have is when the Access file is renamed and new data is loaded, the pivot table still links to the old access file (as it should do). Is there a way in which I can re-point the pivot table to the new file without...

I have access to the file so I won't need to create a seperate file. The code for copying and pasting would be great. Thank you so much for your help!!!

Agreed with fixing things at source but this is not my spreadsheet. Dale could I please have this code. Could be very useful. Thanks.

The formatting is for data labels within a line chart. Therefore unable to access conditional formatting. Have you any other ideas? Thanks for the suggestion.

How do I create an entry in the custom number (of format cells) category to turn a #NA to a blank (""). I can easily create this as a formula but I want it as a format. Please help, this is really frustrating me!