Update Page During Hyperlink

Is there a way to update a page while doing a hyperlink?
I have a page that depending on what the value is on 
page one (with the hyperlink) page two either hides or 
shows certain rows. If I switch pages choosing sheet 
tabs it works perfect. When I use a hyperlink the page
does not update.
Thanks to anyone who can help.
Dave


---
Message posted from http://www.ExcelForum.com/

0
8/18/2004 6:40:03 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
401 Views

Similar Articles

[PageSpeed] 18

Hi,

Not exactly sure this is what you're after but this
code will fire if you click on a hyperlink in Sheet1
(go to sheet2). rightclick on tab of sheet1 and goto
view code - paste.

jeff


Private Sub Worksheet_FollowHyperlink(ByVal Target As 
Hyperlink)
Sheet2.Select
End Sub


>-----Original Message-----
>Is there a way to update a page while doing a hyperlink?
>I have a page that depending on what the value is on 
>page one (with the hyperlink) page two either hides or 
>shows certain rows. If I switch pages choosing sheet 
>tabs it works perfect. When I use a hyperlink the page
>does not update.
>Thanks to anyone who can help.
>Dave
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
0
anonymous (74722)
8/18/2004 8:02:00 PM
Reply:

Similar Artilces:

Hate having to press save just to update cells
I am not sure how this happened. I have been working in the same file for a long time but now all of the sudden, cells won't update until I hit save. Is there a way to fix this. I have a huge file and it is such a pain to wait 10 seconds every time I want to see the calculation appear. ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Software! http://www.ozgrid.com/Services/excel-software-categories.htm ** Check if your calculation is still set to auto. <Tools> <Options> <Calculation> tab, Make sure "Automatic" is checked under...

STUCK in "Update in Progress"
Anyone know how to get M05 out of this? I've deleted IE cache and \temp directories with no avail! Thx, JS ...

Charts that are Off-Screen Disappear after update
I have a sheet in a Workbook that holds about 21 charts. When I add data to the workbook, I need to go into every chart and add rows to each data series as well as the Horizontal Axis. Since this is tedious, I wrote a Macro to do this. The Macro works great...but when I run it, any chart that is off-screen disappears. It still exists, but the only way I can make it visible again is to save the workbook, close it, and reopen it. I have tried to refresh the graphs as I update them, but that hasn't fixed it. The only fix that I have found that works is to temporarily set the Wi...

How do I get rid of blank pages in a report?
Could anyone tell me how to have my report print only where there is data and not to print out blank pages? Thank you. On Tue, 5 Feb 2008 14:27:18 -0800, SIRSTEVE wrote: > Could anyone tell me how to have my report print only where there is data and > not to print out blank pages? > > Thank you. Code the Report's OnNoData event: MsgBox "There are no records to print." Cancel = true If you opened this report from an event on a form, this will raise error 2501. Trap the error in the form's event that opened the report. On Error GoTo Err_Handler DoCmd.OpenR...

Print 2 pages on one page...fill both halves
I am trying to print 2 pages on one page, but I want each page's print area to fill the entire half of the printed page. I can get 2 pages to print on one page, but each page shows up pretty small on each half of the printed page. I've tried many different combinations (fit to 1 page wide and 1 page long, etc...) for each of the pages, but nothing seems to correct the issue I'm having. Any suggestions? Thanks in advance!!! Take a picture of each page and paste them on a new sheet and print it. Select the first area to print then... Hold down the shift key and click the Edit menu....

Purpose of Data Access Page?
Hi, I hope this doesn't seem like a stupid question. What is the purpose of a data access page? It seems to me you can accomplish a whole lot more with forms. Data access pages have many limitations. What would be an example of when you would want to use a data access page over a form? Forms: PC use Data Access page: Web use -- HTH, George "REGREGL" <REGREGL@discussions.microsoft.com> wrote in message news:B59B6E5E-4096-4BA8-98E2-F24AD7305409@microsoft.com... > Hi, > > I hope this doesn't seem like a stupid question. What is the purpose of a &...

30-page newsletter suddenly changed!?
Am using Publisher 2003, have done many, many newsletters but never experienced this b4. Changed font from a previously used advt from earlier NL to another font, changed leading from 1.14 to 1 - and now ALL 30 pages have changed to franklin gothic demi, 1.14 spacing! Any suggestions, anyone, please as to how to return publication back to what it was. Have the horrible thought I am going to have to redo 3 days work of fonting/formatting/etc. Cheers Tranmere36 Create a font scheme to match what you had before. Apply to a text box, select the box, double-click the Painter tool, scroll th...

RW-Page Break on Calc Field
Does anyone know if it's possible to create a page break on a calculated field in the RW section options (or any other method)? I am modifying the PM History Dist. Detail report. I have concatenated Account Segment 2 and 3 and the combination of the two reporesent cost centers. My report works nicely, but I can't get a break (lol). Thanks in advance. -- Jim Lines Sr. Microsoft Dynamics GP Applications Consultant Certified Microsoft Dynamics GP Specialist ...

OL2000: Selecting "send page by e-mail" or "send link by e-mail" in Internet Explorer locks Outlook until message is sent
In Internet Explorer: File -> Send -> Page by E-mail / Link by E-mail. This will open a new message in Outlook. However, the user cannot leave this message open and do other work in Outlook - Outlook behaves as if this new message was a dialog box. This is very annoying. On another note, when selecting the "Page by E-mail" option, Outlook creates a .htm attachment of the web page when plain text is set as the default mail option instead of creating a HTML message. Outlook should let the user choose. Outlook Express creates a HTML message in this case. ...

12.1.5 update
> This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3321542333_1888889 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: 8bit Ok. I�ve tried everything. I have a legal, registered copy of 12.1.0, running on a Macbook Pro running OS X 10.5.6, but try as I might I cannot update to 12.1.5. The update process, after downloading this massive �patch� fails to find a legal copy of my software! (I am writing this on Entourage, which crashed once already during writing this)...

Web Pages appear distorted
I am attempting to put together a small website on my new computer using Publisher 2003 SP2. However, I am experiencing problems when attempting to preview it on said computer (using Web Page Preview). The text and graphics look completely out of place. Yet when I preview it on another computer, it looks exactly like the way I intended it to be (i.e., WYSIWYG). I am not sure if the laptop I am using is the problem. It's a Dell Inspiron E1505 laptop computer with a 15" widescreen display, 1 GB RAM and a 1.8 GHZ Dual Core CPU. Any help is appreciated. Thanks, JR ...

Update KB980182
I downloaded and installed MS update KB980182 and now the computer runs a lot slower when I am using Internet Explorer. I have done everything I can think of to rectify the problem but it does no good. When I unistall the update, IE runs at its normal speed and when I reinstall it, the problem returns, therefore it has something to do with this update. Does anyone else have this problem or have a solution to this problem? "Ward" <Ward@discussions.microsoft.com> wrote in message news:8F756C16-CD2A-4029-A866-0C8D7C7C4A6B@microsoft.com... >I downloaded and in...

2004 Stock Updates Expired?
This is a multi-part message in MIME format. ------=_NextPart_000_0032_01C6D8F2.AA39FC90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Running Money 2004 Deluxe - recent system rebuild and application = reinstall. Just noticed that my stock prices have not updated since 9/1/06 - but my = direct banking downloads have continued to update. Have I run into the 3 year download expiration - w/o receiving any = notice?=20 Last I read, I thought the service would expire in January. They must have my system key flagged from the date of initi...

Update Column with Restricted Collation?
SQL Server 2008, server and database are both set to default Latin CI collation. Some characters are in there that are not valid for consuming systems. I would like to write a SQL-Update that will replace the varchar value with a value with a "restricted collation" like ASCII 7-bit so characters not on a standard US keyboard will be removed. How can I do that? Thanks. On 2010-04-13 22:01, SnapDive wrote: > SQL Server 2008, server and database are both set to default Latin CI > collation. Some characters are in there that are not valid for > consuming syste...

Make a change to an Update Query
I need to make changes to an update query but when I open the desing view it only shows the field that being updated. How do I view the hidden fields? Answered in your prior post John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County JLUTHER wrote: > I need to make changes to an update query but when I open the desing view it > only shows the field that being updated. How do I view the hidden fields? ...

Possible solution to .NET Framework Updates
Like many of you, I have been grappling with unsuccessful .NET Framework updates. Hopefully, this post might help you. I am operating from Windows XP Home Edition SP3 - 32bit. What I did... From Control Panel - Add And Remove Programs, I removed .NET Framework 1.1 (it had SP1 on top) NOTE: Add and Remove Programs would NOT allow me to remove .NET 2.0 SP2 or 3.0 SP3. I DID NOT USE THE WINDOWS UNINSTALL CLEAN UP UTILITY. I attempted to uninstall .NET 3.5 SP1 and it allowed me to do so. The program asked if I wanted to Uninstall or Repair the program. I SELECTED REPAIR. T...

Merge 3 Xls worksheets updates into master xls
I have several xls spreadsheets that all have the same columns, I want to merge updates in three xls spreadsheets into another spreadsheet which is my master thus updating the master with data from the three other xls files. Is there a software program out that does this? Or a command I can use that will do this? Thanks ...

hyperlink filename #
Is there a way or trick or workaround to generate a hyperlink in a cell which points to a file which happens to contain a "#" (pound) in its filename? I've always changed the filename. HAS wrote: > > Is there a way or trick or workaround to generate a hyperlink in a cell which > points to a file which happens to contain a "#" (pound) in its filename? -- Dave Peterson ...

Blank pages
This morning, on both my laptop and desktop using IE8 8.0.7600.16385, certain stories on smh.com.au "disappear" after a few seconds. It also occurs in the online version of theage.com.au, part of the same group. I downloaded Firefox and there is no problem. It seems unlikely IE could have been corrupted on both machines. Is there some add-on I need? Thanks Bill Hi, Tools> uncheck InPrivate Filtering Regards. "Bill" <willy@home.om> wrote in message news:OrAS9scqKHA.5940@TK2MSFTNGP02.phx.gbl... > This morning, on both my la...

Bad certificate on MS Windows Update sites
I pulled up the following MS site via IE 8 - Version 8.0.6001.18702 - Build 86001. https://v4.windowsupdate.microsoft.com https://v5.windowsupdate.microsoft.com I received the error message: There is a problem with this website's security certificate The problem is I had just 'updated' my Microsoft Trust Certificate via the process. 1. In Control Panel, open Add or Remove Programs 2. Click Add/Remove Windows Components. 3. Select the Update Root Certificates check box. 4. Click Next, and then click Finish. So I have the following questions. [1] Is there...

Can you have more than one hyperlink in a cell in Excel?
If you can have more than one hyperlink in a cell - what do you separate the hyperlinks with? Check this: http://excel.tips.net/Pages/T002805_Putting_More_than_One_Hyperlink_in_a_Cell.html Micky "Vickie" wrote: > If you can have more than one hyperlink in a cell - what do you separate the > hyperlinks with? You could cheat and add rectangles over the words/phrases you want. Then hide the borders and assign a hyperlink to each of the rectangles. You could even format those characters (if the value in that cell is not a formula) nicely. But it can be a ...

Align object on back of page
I am making a gift tag with publisher using cardstock. I want a picture on front. On the inside needs to be To: / From: Like a greeting card only much smaller. My problem is that I cannot find a reliable way of alinging the front and back. Is there a simple way of knowing where to place the graphics and text inside. I tried the greeting card but it is far too big. Of course the 4 fold won't work either. If you want them all alike, setup one of the label templates and insert another page for the back. When you go to print, print current page, turn the card stock over and print the second...

first page of brochure from other papertray?
Is there a workaround in MSPUB 2003 for printers that don't support the function: 'take first page from tray X' and 'the rest of the pages from tray Y' on 1 printjob. I like to print an A4 doublesided brochure using a heavier papersort for the cover. I know MSWord can do this using sections. I like to replace and old HP color laserjet which does support this in the Windows printerdriver, with an Epson Aculaser which don't. Create a new publication for the cover. If your printer doesn't support a different paper for the first page this probably is the only worka...

Publisher 2003 Extra Blank Pages
Hi All, Publisher Version 2003 I have a 12 page document that I have used for 7 versions of a newsletter without any problems. I open up the previous one, delete the content, save with a new name and start again. However, it has now started to print an extra blank page after each page with content. These blank pages do not show up in the document but only when I use Print Preview, Print to a printer or try to create a pdf. I have tried to print to different printers with the same result. The document is a simple 12 page document. ie not a booklet. I can get around it temporarily by printing ...

Window XP Update
Hi everyone I have an HP m7480n computer 3.0GHz, 2.00 GB RAM expandable to 4.00 GB and 280 GB of hard drive , NVIDIA GeForce 7300 LE video card ect .... I bought it about 2 years ago and since then i had quit a few problem. Last fall the manufactor had to replace the mother board and power supply , i had to format the drive in january because of a virus and two days ago i had to do the same again .... talk about bad luck ... lol . I have done all the update that needs to be done from HP and Microsoft and my system is working fine now except for one issue ... there is an update that d...