All the time
Most of the time
Rarely
Never
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)
That isn't a macro, it's a function and they don't appear in the macro list.
Be as you wish to seem
You'd better not use a function to change the layout of a worksheet.
You can if you are not calling it from a cell.
Be as you wish to seem
So what should I do if a function is not the best solution?
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
Use a Sub not a Function. Unless you are returning a value there is no point in using a function generally.
Be as you wish to seem
It worked. Thanks so much
Posting Permissions
Reply With Quote
