Office 2010 macro error - Not all steps recreated in macro - Help!

**duffer** · 12-21-2011, 09:36 AM

I'm using Office 2010 on Windows 7 64bit. I previously had no problems on my old PC (Vista 32bit - Office 2007) in creating and using this simple macro. All this macro does is some basic calculation & formatting.

The problem is that when I execute the macro on the tabs, there are 3 steps missing, specifically -

Adding the tab name to the centre header (nothing appears)
Adding the page of page to the centre footer (page number appears but total pages doesn't appear)
Adding the date to the right side footer (nothing appears)

All other steps seem to be fine. This is causing me great pains as I have to manually insert these 3 steps to every tab.

Now, I'm not a programmer and do not understand visual basic, so layman's terms please. From what I can see, the VB code contains those 3 steps (which I have highlighted below) so any help would be much appreciated. Many thanks! -

Please Login or Register  to view this content.

**royUK** · 12-21-2011, 09:41 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**JapanDave** · 12-21-2011, 10:15 AM

What exactly are you trying to do with your macro?

**dangelor** · 12-21-2011, 11:10 AM

I would suggest turning on the macro recorder and recreate your print settings. Comparing the results with the original code may suggest a solution.

**duffer** · 12-21-2011, 11:20 AM

Hi, I just need to add the name I have given to each tab to the header and also to have the total number of pages on each footer.

We use a very limited database and I need to put the annual sales quantities for each client on a separate tab/page. This information is exported from the database into Excel via copy & paste. I just need to smarten up the 'look' of the data. However the data doesn't include the name so I name each tab and using this macro I add the tab-name to the header. I suppose I could write the name on the sheet as well but I'm wondering why is this not working for me.

Many thanks!

**duffer** · 12-21-2011, 11:23 AM

Originally Posted by dangelor

I would suggest turning on the macro recorder and recreate your print settings. Comparing the results with the original code may suggest a solution.

I used the macro recorder in the first place. Do you mean I should try with a new file? I do this thing often and it has always worked in Office 2007. It's since I got my new pc with Office 2010 that I have this problem.