L
Lance
I am having a problem with the Print_Area name.
I have set up a custom print_Area formula using insert->name->define
so that my print range is dynamic based on certain selections a user
makes regarding some calculations
My problem comes when a user attempts to use the page setup screen.
When looking at page setup, the formula does not exist - only the
current absolute range. When the user pushes okay from page setup
(even without changing the actual print area) the print_area formula
resets to the aboslute. Is there a way to keep from allowing the print-
area to update when someone goes into page setup to modify other
criteria?
I am attempting to resolve this without the use of a macro (which
would make the solution to set print area right before printing
occurs) since there are no other macros in the book.
Any ideas? Or am I stuck without a macro?
I have set up a custom print_Area formula using insert->name->define
so that my print range is dynamic based on certain selections a user
makes regarding some calculations
My problem comes when a user attempts to use the page setup screen.
When looking at page setup, the formula does not exist - only the
current absolute range. When the user pushes okay from page setup
(even without changing the actual print area) the print_area formula
resets to the aboslute. Is there a way to keep from allowing the print-
area to update when someone goes into page setup to modify other
criteria?
I am attempting to resolve this without the use of a macro (which
would make the solution to set print area right before printing
occurs) since there are no other macros in the book.
Any ideas? Or am I stuck without a macro?