Code to create Header not always working

**summit73** · 11-30-2012, 01:24 PM

I have the following code, which works well when saving a file. However, the code is not working when saveas is used.

I am new to coding and need to know what can be added to make this work with either save or saveas.

Please Login or Register  to view this content.

Thanks is advance to anyone who can offer assistance.

EDIT:
Is there a way to use code to force a save immediately after a saveas (without creating a never ending loop)? This may be a work around that would fix this particular issue.

EDIT 2:
I have temporarily added code to add a msgbox after the save event as a temporary warning to users. I would still prefer to have a resolution to this issue rather than a warning.

**GaidenFocus** · 11-30-2012, 01:58 PM

When you use save as, your macro runs, but is based on the old work book name. You could just hit save again after doing save as to work around this.

**summit73** · 11-30-2012, 02:04 PM

I had already noticed this work around. The problem is that this workbook will be used by others in the office that may not remember to hit save again after the saveas action.

If possible, I need the code to run with either action and not require the extra save after a saveas. (Confusing much?)

**summit73** · 12-11-2012, 11:35 AM

For those searching the site for answers, I never got the solution that I was hoping for. However, I did make my excel file work the way that I wanted by using the same code with several different events.

Please Login or Register  to view this content.

Code to create Header not always working

LinkBack

Thread Tools

Rate This Thread

Display

Code to create Header not always working

Re: Code to create Header not always working

Re: Code to create Header not always working

Re: Code to create Header not always working

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions