Macro problems in the Personal Macro Workbook

August 31, 2011 at 12:48:45
Specs: Windows XP
Hi, I'm creating a very basic macro to include headers and footers in an excel workbook. I want this to be used by any open file so I'm storing it in the Personal Macro Workbook. If I type in text to be displayed like my company's name, its fine, but if I use the fields which suppose to pull the data from the file, like page number or file name, When I run macro I do not see it. I can see the typed text but not the page number or file name. When I go to the VBA window the coding for the field is there but its not showing in my file. Macros are also enabled in my options box, so can anyone tell me what is causing this?,

See More: Macro problems in the Personal Macro Workbook

Report •

August 31, 2011 at 14:04:30
Since we can't see your workbook or macro from where we're sitting, it's a little tough for us to offer a solution.

We need more info.

Please click on the following line, read the instructions found via that link and then post whatever you think we'll need in order to help you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question