LinkBack URL
About LinkBacks
Hi,
I am designing a website layout in excel so that it will be easier to develop.
I need to show a worksheet as a pop up window when a hyperlink is clicked. Can any one help me on this.
Regards,
Tava
Hi,
I am designing a website layout in excel so that it will be easier to develop.
I need to show a worksheet as a pop up window when a hyperlink is clicked. Can any one help me on this.
Regards,
Tava
Hi Tava,
welcome to the forum.
I don't think Excel 2003 offers that functionality natively. I assume you want to re-create a target="blank" behaviour for a clicked hyperlink? This can probably be done using VBA.
I'll move the thread to the Programming Forum to catch the attention of the wizards there ...
cheers
Hello Tava,
Without the benefit of your code and layout, I will show you the basic construct to create a pop up window from a hyperlink in HTML. This example also allows you to set certain display properties of the pop up window. To see this code better, copy the examples into Word or NotePad.
You may wish to create a link to close your pop-up window. Here's the code:
Please Login or Register to view this content.
Here is an example taken from a tutorial web site that displays their "About" page. This show how to set the display properties.Please Login or Register to view this content.
You will need to adapt this code to your situation, as these are just code examples on how to create the pop up window.Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Ross,
Thank you for your reply. I am sorry that I was not very clear about my requirements. I am not looking for code to create pop up window in a web page. I am making a PROTOTYPE of a web page in an Excel sheet so that I know how the page should look like and what functions it should have.
To do this I have prepared a excel workbook. Now I want a hyperlink/button in one of the worksheet which when clicked should open a pop up window. In this pop up window I want to show another "worksheet" which I have prepared separately.
All this to be done in a MS-Excel workbook. I believe I need to work with some VBA codes but I need some start.
Appreciate your help.
Regards,
Tava
I can't understand why you are designing a web page layout in Excel, isn't this doubling the work?
Not sure if this is what you want
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
hammer and nail? q.e.d.I can't understand why you are designing a web page layout in Excel,
And even if the resulting workbook is saved as a web page, the VBA code will not workOriginally Posted by teylyn
Hi,
Well the purpose of creating the web page prototype in excel is to gather the required information and presenting it to the team members quickly. The same sheet can be emailed to other teams for review and getting their comments.
Later we will use this as a bible to create the actual web page using JSP/CSS/HTML, JAVA etc.
I want to show the pop up screens in excel because then it will be easier for other people to distinguish from other pages. I have seen this kind of worksheet before but could not remember how they did it.
I would be really grateful if any one can shed some light on this.
Regards,
Tava
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks