Question about Microsoft Computers & Internet

1 Answer

Closing Worksheet on executing Hyperlink command

I use Excel 2003. I created worksheet A where there is a link to another worksheet B. After studying worksheet B,
I again move to Worksheet A using Hyperlink command and address of Sheet A.
My requirement is that sheet should close on execution of hyperlink.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

You could do this by creating a close button with the worksheet- Do this via insertin ga prompt in Macro.

Posted on May 22, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I want to copy an Excel chart as a Image onto a PowerPoint Slide (Office 2007). What is the sequence of APIs to apply?


Copy worksheet data to a PowerPoint presentation
  1. In Excel, select the worksheet data that you want to copy to a PowerPoint presentation.
  2. On the Home tab, in the Clipboard group, click Copy za006044679.gif.

za010165428.gif

Keyboard shortcut You can also press CTRL+C.

  1. Click in the PowerPoint presentation where you want to paste the copied worksheet data.
  2. On the Home tab, in the Clipboard group, click Paste.

Keyboard shortcut You can also press CTRL+V.

  1. Click Paste Options za006043532.gif next to the data, and then do one of the following:
    • To use the original format of the copied data, click Keep Source Formatting.
    • To use the document theme that is applied to the PowerPoint presentation, click Use Destination Theme.
    • To paste table data that you copied as text, click Keep Text Only.

Notes

  • If you don't see the Paste Options button, you may have to turn it on. Click the Microsoft Office Button za010077102.gif, and then click PowerPoint Options. In the Advanced category, under Cut, Copy, and Paste, select the Show Paste Options buttons check box.
  • If you paste the data into a PowerPoint table, the Paste Options button is not displayed.
Tips
  • To paste the data in another format (such as a worksheet object, HTML format, bitmap, picture, or to text format) or to paste a link to the source data in Excel, on the Home tab, in the Clipboard group, click the arrow on the Paste button, and then click Paste Special. In the As list, click the format that you want to use.
    • If you want to edit the entire worksheet later, click Microsoft Office Excel Worksheet Object. Clicking Microsoft Office Excel Worksheet Object provides access to the entire worksheet in the presentation, including data that you may want to keep private. To automatically update the table in the presentation when changes are made to the source data in Excel, click Paste link. Both of these options also preserve the Excel formatting, even when the formatting features that are used are not supported in PowerPoint. If you saved the source workbook before you copied the data, you can also click Attach Hyperlink to insert a hyperlink in your presentation that directs you to the source data in Excel.
    • To paste the content as an Object Linking and Embedding (OLE) (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) PowerPoint application icon (rather than pasting the actual content), click Microsoft Office Excel Worksheet Object, and then select the Display as icon check box. You can click the icon to open the application and then view the content.
    • If you want to use HTML to copy the data to PowerPoint into a PowerPoint table, click HTML format.
    • To paste a static picture, click Device Independent Bitmap or Bitmap, or to paste a picture that can be ungrouped, click Picture (Enhanced Metafile) or Picture (Windows Metafile).
    • To paste the data as formatted or unformatted text, click Formatted Text (RTF) or Unformatted Text.
  • To paste the data as a hyperlink that directs you to the source data in Excel, click the arrow on the Paste button, and then click Paste As Hyperlink. If the workbook that contains the source data has not been saved yet, this option is unavailable.
  • If you want the range of data that you paste as a Microsoft Excel Worksheet Object into a PowerPoint presentation to expand when the corresponding data expands on the Excel worksheet, you can define a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) for the range of data in Excel before you copy the data. You can then paste a link to the named range by using the Paste Special command. On the Home tab, in the Clipboard group, click the arrow on the Paste button, click Paste Special, and then click Paste link. This works only when you copy data that is not in table format in Excel.

Mar 09, 2011 | Individual Software Professor Teaches Word...

Tip

How to find no. of rows and columns in Worksheet.


Hello everybody, this would be my first tip on FixYa.com. Number of people might not be aware how many rows and columns are there in Microsoft Worksheet.
This is how you can find out.
1. Select A1 cell in the worksheet
2. Now press Ctrl + down arrow from your keyboard, that will take you to the bottom of the row. You can find the number on the left side.
3. Again select A1 cell in the worksheet and press Ctrl + left arrow from your keyboard, that will take you to the last column of the worksheet. Now to number, just type "=column() " , without quotations, that will give you the number of the column.
Microsoft Worksheet columns is number from A to Z, again from AA to AZ, again from BA to BZ and so on till it reached IV in Excell 2003 and earlier version.
Microsoft Excel 2003 and old version has 16,777,216 cells per worksheet (65,536 rows * 256 columns).
Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).


on Jul 27, 2010 | Microsoft Excel for PC

1 Answer

How many charts can put in a sheet?


194a9e0.jpg

In Microsoft Excel 2003 for PC, you may add at least 32 charts as as objects into a worksheet (as illustrated above), however it appears that you may add as many charts as you wish into a worksheet using this method .

Dec 10, 2009 | Microsoft Excel 2003 (06503995)

3 Answers

How can enable mail recipient as attachment excel


MAIL RECPEINT AS ATTECHMENT OPTION NOT VISIBLE IN MY OFFICE 2003 PROFESSIONAL

Apr 11, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

I have worksheet one & worksheet 2. I want to compare the data from worksheet 1 to worksheet 2 but some of the data from worksheet 1 are not available in worksheet 2. How do i do that?


depends on your version of Excel

2003 - unfortunately not so apparent - easiest copy one worksheet to another (new) workbook then go to Window>>Compare Side by Side with option (while both workbooks are open)

2007 - on the Window section of the View tab - click New Window then View Side by Side icon (next to Split) - you may have to arrange the two windows to be side by side as it may come up one on top of the other (click on Arrange All in the Window section to choose Vertical vs. Horizontal)

Mar 26, 2009 | Computers & Internet

1 Answer

Automatically creating a new worksheets


You can not do it by formulea but there is something called as ***-in you need to create add -in for this

I will suggest you that get a small program for doing this which will do all buisiness processing automatically will give you lots of benifits such as notification error catching and all.

If you need anything else,let me know.

Dec 17, 2008 | Microsoft Office Excel 2003 for PC

1 Answer

Create link from system generated report to another sheet


the easiest way to do that is use hyperlink.
right click on the cell you want and select the hyperlink and link it to other worksheet or document you want.
one caution: if you are going to copy the worksheet to other than where it is now, you have to copy all of the attached worksheet and document. otherwise, you will get a error message.

Nov 05, 2008 | Microsoft Windows XP Home Edition

1 Answer

Print area in worksheet


1. Select area you want to print.

2. When you click Print, you getting Print window.
In "Print what" frame choose "Selection" option.

Sep 17, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Import data from access into excel where one column go into one worksheet and other into next


Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

Jun 10, 2008 | Microsoft Office Access 2003 (077-02871)...

2 Answers

EXCEL


It is very useful to learn excel shortcut realy i thank you

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

162 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18384 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...