Can not view macros in Personal.xlsb from macro dialog box

[eaddi]

Hello,

I need help.

:) The Good
1. Personal.xlsb opens when I start excel and is unhidden
2. I can open VB Editor and see the macro just fine
3. I can select the module from the VB Editor window, click run, and it works just fine



:banghead: The Problem
1. I cannot see the marco saved to my Personal.xlsb from the Macro Dialog box in Excel (Developer>Macros)
2. The short cut only works after I have ran the macro (by pressing play)

[Aflatoon]

That isn't a macro, it's a function and they don't appear in the macro list.

[snb]

You'd better not use a function to change the layout of a worksheet.

[Aflatoon]

You can if you are not calling it from a cell.

[eaddi]

So what should I do if a function is not the best solution?

[eaddi]

Hit post to soon. We need to set the print format for 5 files that are all identical. I need a simple macro to that will perform this function. The print setting will always be the same, but the tabs in each file are named something different.

Ex: I want to set the print options to 1 page long and 1 page wide for each of the files below without having to create a marco for each.

File 1
tab1 is named A
tab2 is named B
tab3 is named C

File 2
tab1 is named D
tab2 is named E
tab3 is named F

[Aflatoon]

Use a Sub not a Function. Unless you are returning a value there is no point in using a function generally.

[eaddi]

It worked. Thanks so much