Custom Views Applicable to the Entire Workbook
 

Hi All!

I have a worksheet that refelcts the lifecycle of a project...and it is
pretty large. I want to make it easy for my users to work with, so i wanted
to create views, recorded in macors, and then linked to Command Buttons.
Unfortunately, the views only apply to the sheet on which they were recorded.

I would like to have standard views set up on a template worksheet, so that
when a new project is added and the worksheet created, the command buttons on
that new sheet trigger the macros executing the views just for that sheet.

As it is now, if I create views on ProjectA, do macros, link them to Command
Buttons and then make a copy of the sheet as ProjectB, when I click on the
button on ProjectB, the view on ProjectA cahnges.

To me, this is much like flipping the lightswitch in the bathroom and having
the garage door open.

Is there a way to make standard views and buttons applicable to an entire
workbook instead of just to one worksheet?

Thanks!
--
Greg