software

I have an expense report worksheet consisting of 12 tabs. Each tab has areas
for the appropriate number of weeks that month for doing expenses. I created
custom views (thanks for the help on that 12/27). I did the 4 views for Jan
tab but when I tried to do it for the Feb tab it goes through all the steps
but doesn't actually show the view as it did in the Jan tab. Why? How do I
get around this? How can I put buttons on each tab to allow someone to
automatically view then print a given week's expense report? Thanks for any
assistance.


I think you have to make the Views you want for each sheet. I just tried
it on an example (created a Custom View on Sheet1) when I was on Sheet2
- and run the View - It goes back to Sheet1.
For the button part of selecting the views - You might try doing a
macro - then make a CUSTOM TOOLBAR and adding the macro to the toolbar.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=496677First of all, I believe that anyone using Custom Views should place a
quot;Custom Viewsquot; window on their toolbar or their menu bar.
This displays the name of the current displayed view, plus it has a
drop-down (expanding) feature which allows you to click on any created view,
and go to it instantly, much like a hyper link.

Right click in the toolbar and choose quot;Customizequot;.
Under the quot;Commandsquot; tab, click on quot;Viewquot; in the left window.
In the right window, you'll see the quot;Custom Viewsquot; window.
Click on it and drag it either to the toolbar or the menu bar.
While the quot;Customizequot; dialog box is *still* open, you can click in the
quot;Custom Viewsquot; window that you just placed to select it, and then you can
drag the left or right border to enlarge it.

Now, when you create your views, include the sheet name, such as quot;JanView1quot;,
quot;FebView1quot;.
You'll now be able to quot;jumpquot; from month to month, view to view, simply by
clicking in the quot;Custom Viewsquot; window.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
quot;SteveMquot; gt; wrote in message
...
gt; I have an expense report worksheet consisting of 12 tabs. Each tab has
areas
gt; for the appropriate number of weeks that month for doing expenses. I
created
gt; custom views (thanks for the help on that 12/27). I did the 4 views for
Jan
gt; tab but when I tried to do it for the Feb tab it goes through all the
steps
gt; but doesn't actually show the view as it did in the Jan tab. Why? How do
I
gt; get around this? How can I put buttons on each tab to allow someone to
gt; automatically view then print a given week's expense report? Thanks for
any
gt; assistance.