Question about Computers & Internet

1 Answer

Excel [ 2003 version] won't allow me to copy a worksheet inside a workbook, so I have a 2nd copy which I want to modify. I.E When I right click my mouse on the worksheet tab, and select copy, and then paste...nothing happens. This is ONLY in workboosk where macros have been used . Solution?

Posted by on

  • 1 more comment 
  • mewiebe Sep 12, 2009

    No it is not in REad only mode...I have several workbooks that have aquired this problematic attribute, after macros were used to move data form on workbook to the ones that now have this problem..

  • mewiebe Sep 12, 2009

    Someone else worte the macros for me and I don't know where to look for them.

  • mewiebe Sep 13, 2009

    Ok that worked ..pressing ALT+ F8...I see the 5 macros...but I don't knwo what to do about them,..

    Someone else wrote them for me.



    Anything else you can do for me? or suggest?



×

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 1,884 Answers

I hope the workbook is not in read only mode. If so then it has to be undone.

Posted on Sep 12, 2009

  • 1 more comment 
  • Vinay Tevatia
    Vinay Tevatia Sep 12, 2009

    Macros may be causing this problem. Check them for any logic problems.

  • Vinay Tevatia
    Vinay Tevatia Sep 12, 2009

    you will find macros in Tools. Alternatively you can press Alt+F8. If that fails then you will have to ask your friend what he did and check and correct them.

  • Vinay Tevatia
    Vinay Tevatia Sep 13, 2009

    Now you will have to tell your friend who wrote these macros as I am not aware of your requirements and his line of thought while writing the macros.
    I have told you where the problem lies and who can rectify it for you.

×

Ad

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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to convert .shs file to .xls format in office 07.pls help......


1. Open a blank Excel workbook by selecting "New" from the "File" menu.
2. Drag and drop the .shs file on to the new workbook by highlighting the scrap file icon on the desktop and dragging it onto the worksheet. Alternatively, you can copy and paste. To do this, click the scrap file icon, and then right-click and select "Copy" from the pop-up menu. Left-click on the Excel workbook, and then right-click and select "Paste" from the pop-up menu. The information stored in the scrap file should now appear within the worksheet.
3. Save the file. Select "Save As" from the "File" menu, and then enter a file name in the box at the top of the window that opens. By default, Excel saves files in the workbook format native to the version. For versions prior to Microsoft Office 2007, this is the .xls format. If you have Excel 2007 or later and want to save the file as .xls, select this format from the "Format" drop-down menu below the box where you entered the file name.

Feb 11, 2015 | Computers & Internet

Tip

How to password protect Microsoft Office Excel 2003


Excel, a part of the Microsoft Office suit, offer password protect feature to prevent unauthorized users from viewing or modifying a *.xls (Microsoft Excel) file data, we can password protect MS Excel 2003 files so that only certain people can control the information.

Before Excel 2003 password protecting, here are a couple of notes:

1. Before password-protecting a workbook or worksheet, you have to consider writing down the password and keep it secure. That way, if you lose or forgot the Excel password, it will be easier to recover the information.
2. Excel has two types of password. One is "password to open" and the other one is "password to modify". You can password-protect the worksheet against modifications so that give some people read-only access to a workbook, or you can password-protect the workbook against opening an entire workbook of multiple worksheets.
3. Microsoft Excel supports several types of encryption settings, including Microsoft Base Cryptographic Provider V1.0, Microsoft DH Schnabel Cryptographic Provider, Microsoft Strong Cryptographic Provider, and more. However, password protecting an Excel file does not 100% guarantee that the password can not be decrypted or the password hacked. You can learn more about how to recover Excel password from SmartKey official site.

Now follow these steps to password-protect Excel 2003.

Step 1: Save your *.xls Excel file
Point to the File Menu, click save as and input the file name then the *.xls file is saved on your local disc. Point to "Tools" - "Options". When the "Options" multi-tabbed dialog box appears, click the "Security" tab.
amenchan.jpg
Step 2: Choose the password protect type
  • If you don't wish other users to view your Excel workbook, enter a password in the "Password to open" box, and then click OK.

  • If you agree other users to view your Excel workbook but don't want them make changes to the workbook, type a password in the "Password to modify" box.

  • If you wish to use a different encryption settings type, click Advanced, choose an encryption setting type you want in the list, and then click OK. And you can also specify the number of characters in the Choose a key length box.
amenchan_0.jpg

Step3: Confirm your password
After type your password, a "Confirm Password" box will prompted, retype your passwords to confirm, then click OK.
amenchan_1.jpg
Step4: Resave the Excel spreadsheet.
After password protecting your Excel file, click Save. All the steps are finished.

Tips:

All the original articles are authorized by SmartKey, welcome To Transshipment but Please Retain the original.

If you are interesting in Excel Password Recovery, please visit our website.

on Dec 20, 2010 | Computers & Internet

Tip

How to protect MS Excel file using password?


In Microsoft Excel, you can protect a single cell, group of cells on a worksheet or an entire workbook by applying password so that unauthorized person can not display as well as modify your document. You can apply two types of password.
Password to open the document:
If it is applied then you have to give the correct password to open the workbook. Otherwise you cannot open the workbook.
Password to modify the document:
If it is applied then you have to give the correct password to modify the workbook. Otherwise your workbook is opened but you cannot modify the workbook. It means that your workbook becomes read-only.
To apply a password to MS Excel document, follow the given steps:
First click on "Tools" menu and select the "Option" from drop down menu.
A windows dialog box will appear, here select the "Security" tab.
Enter first password in "Password to open" text box under "File encryption settings for this workbook" section and second password in "Password to modify" text box (if required) under" File sharing settings for the workbook" section then click "Ok" button of dialog box.
Microsoft Excel will open "Confirm Password" dialog box for the confirmation of passwords. The maximum length of password is 15 characters.
Re-enter the password to open and password to modify and click "Ok" button of Confirm Password dialog boxes one by one.
Now close the file and then reopen to test the password.

on Dec 03, 2009 | Computers & Internet

5 Answers

Excel sheet has been lost how to recover


Lost Excel file can be recovered from:
  1. Recycle Bin - If you have deleted the file with normal delete.
  2. Backup - If have maintained the backup of file.
  3. Email - It may possible that you have mailed the file to someone.
  4. 3rd Party Recovery Software - Recuva, Stellar Data Recovery ...

Oct 29, 2012 | Microsoft Office Excel (License Only)...

2 Answers

What is a workbook?


A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheet

The term spreadsheet is often used to refer to a workbook, when in actual fact, spreadsheet refers to the computer program, such as Excel.

So, strictly speaking, when you open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.


Jun 25, 2011 | Microsoft Office Excel 2007 Full Version...

1 Answer

How do you combine three excel documents into one


For simplicity I'll assume each Excel document is one worksheet.
We'll call them Document1 Document2 and Document 3.

We'll move Document2 and Document3 to Document1

Open all three documents. In Document2 click the EDIT menu, then select MOVE OR COPY SHEET... In the box TO WORKBOOK, select Document1, then click OK.

In Document3 click the EDIT menu, then select MOVE OR COPY SHEET... In the box TO WORKBOOK, select Document1, then click OK.



If you have a mouse with right click you can do it as follows:

Open all three documents. In Document2 right click the worksheet tab and select MOVE or COPY. In the box TO WORKBOOK, select Document1, then click OK.

In Document3 right click the worksheet tab and select MOVE or COPY. In the box TO WORKBOOK, select Document1, then click OK.

Jun 17, 2011 | Microsoft EXCEL MAC UPGRADE 2008 Upgrade...

1 Answer

HOW DO I ADD TABS TO MY SPREADSHHET IN MS WORKS


I do not think that works contains tabs. Microsoft Excel which is part of the office suite has what is known as a workbook and each workbook has individual worksheets that contain tabs along the bottom of the workbook. You can add new tabs there by right clicking and selecting insert and then select worksheet. You can also rename the tab with the right click option as well. These instructions are for microsoft excel 2003.

Aug 02, 2009 | Dell Computers & Internet

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

Matching data


1. Open up both workbooks.
2. Copy one worksheet from one workbook to another using.
Right click on the tab of one book and Select "Move or Copy"
3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.
4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.
5. Sort each worksheet by students name. Data..Sort.
6. Copy the scores from one sheet to another.
7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.

Apr 29, 2008 | Microsoft Excel for PC

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

Related Topics:

24 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

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

Answer questions

Manuals & User Guides

Loading...