Requesting macro to either alternate page number orientation, or keep the same

[Butcher1]

Admin Sheet has a drop down menu in A18 with either single sided pages or double sided pages. Journal has page numbers that are currently alternating left and right for even and odd, so if they were printed out double sided, the page number always be on the outside of the page as they sat in a binder.

I need a macro that will adjust the page numbers to all far right alignment in the footers of Journal sheet if single sided pages are selected in Admin Sheet A18.

If double sided sheets is selected, it needs to make odd page numbers far right orientated and even page numbers far left orientated.

Thank you so much.

[mthroesch]

Place this in the VBA code for the sheet you want to do that with

Please Login or Register  to view this content.

[Butcher1]

I named the macro Align_Page_Numbers and it wouldn't work for me, sorry, I am a newb to programming.

[mthroesch]

i did realize this was a cleaner method not by much but removes some code. just put this in the VBA code for the Worksheet labeled "Journal" or what ever you are going to call it

Please Login or Register  to view this content.

[mthroesch]

I named the macro Align_Page_Numbers and it wouldn't work for me, sorry, I am a newb to programming.

no need to create a macro this will set the page numbers when you click the journal sheet

[Butcher1]

Thank you.

[mthroesch]

glad to help