ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custom view for one workbook (https://www.excelbanter.com/excel-discussion-misc-queries/106448-custom-view-one-workbook.html)

pltplt

Custom view for one workbook
 
I have created a workbook to track the performance measures for several
departments. It will be in a network folder for any number of employees to
review. I would like to set a custom view to turn off the sheet tabs,
formula bar, tool bars and just display the report (hyperlinks navigate the
user thru the workbook). My problem is when I turn off the above it affects
all my workbooks. How can I restrict it to this workbook only?

RagDyeR

Custom view for one workbook
 
It's not supposed to do that.
It works fine for me, and I'm using Custom Views in 3 different versions:
XL97, - XL2K, - XL02

Exactly what procedure are you following?

Just a note he
Before I change anything, I set the first view as "Orig", so that I can
easily and quickly return to the default WS settings.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"pltplt" wrote in message
...
I have created a workbook to track the performance measures for several
departments. It will be in a network folder for any number of employees to
review. I would like to set a custom view to turn off the sheet tabs,
formula bar, tool bars and just display the report (hyperlinks navigate
the
user thru the workbook). My problem is when I turn off the above it
affects
all my workbooks. How can I restrict it to this workbook only?



pltplt

Custom view for one workbook
 
I'm just unchecking everything so it won't show.

"RagDyer" wrote:

It's not supposed to do that.
It works fine for me, and I'm using Custom Views in 3 different versions:
XL97, - XL2K, - XL02

Exactly what procedure are you following?

Just a note he
Before I change anything, I set the first view as "Orig", so that I can
easily and quickly return to the default WS settings.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"pltplt" wrote in message
...
I have created a workbook to track the performance measures for several
departments. It will be in a network folder for any number of employees to
review. I would like to set a custom view to turn off the sheet tabs,
formula bar, tool bars and just display the report (hyperlinks navigate
the
user thru the workbook). My problem is when I turn off the above it
affects
all my workbooks. How can I restrict it to this workbook only?





All times are GMT +1. The time now is 07:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com