G
Greg in CO
Hi All!
I am reposting this with some additional information:
Here is the code for two of the macros which each trigger a custom view.
One (FULL_VIEW) will unhide all the rows on the worksheet. The other
(SUMMARY_VIEW) will hide all the rows except the summary data at the top.
The views and the macros have the same names/naming convention and when I
opened the VB Editor, the macros were located in the window for Module 7.
*************************** Code Starts Below
Sub SUMMARY_VIEW()
'
' SUMMARY_VIEW Macro
' Macro recorded 8/27/2008 by Greg Starr
'
'
ActiveWorkbook.CustomViews("SUMMARY_VIEW").Show
End Sub
Sub FULL_VIEW()
'
' FULL_VIEW Macro
' Macro recorded 8/27/2008 by Greg Starr
'
'
ActiveWorkbook.CustomViews("FULL_VIEW").Show
End Sub
**********************Code Ends Above
The project worksheet that reflects 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 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, but they only change on that sheet. This will be
a shared workbook, so there could be users changing views on different
worksheets simultaneously.
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 available for the entire workbook, but
when you use the buttons, they are applicable only to the active sheet where
the button sits?
Thanks!
I am reposting this with some additional information:
Here is the code for two of the macros which each trigger a custom view.
One (FULL_VIEW) will unhide all the rows on the worksheet. The other
(SUMMARY_VIEW) will hide all the rows except the summary data at the top.
The views and the macros have the same names/naming convention and when I
opened the VB Editor, the macros were located in the window for Module 7.
*************************** Code Starts Below
Sub SUMMARY_VIEW()
'
' SUMMARY_VIEW Macro
' Macro recorded 8/27/2008 by Greg Starr
'
'
ActiveWorkbook.CustomViews("SUMMARY_VIEW").Show
End Sub
Sub FULL_VIEW()
'
' FULL_VIEW Macro
' Macro recorded 8/27/2008 by Greg Starr
'
'
ActiveWorkbook.CustomViews("FULL_VIEW").Show
End Sub
**********************Code Ends Above
The project worksheet that reflects 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 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, but they only change on that sheet. This will be
a shared workbook, so there could be users changing views on different
worksheets simultaneously.
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 available for the entire workbook, but
when you use the buttons, they are applicable only to the active sheet where
the button sits?
Thanks!