Question about Microsoft Excel for PC

1 Answer

Macros Help PLZ

Macros help 14 Mar 2008 - I accidentally hit disable on my workbook then closed. Now when I try to open
my workbook (that now has a xlms extention) I get This file is not a
recognizable format, how do I get my work back to where it was?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Contributor
  • 51 Answers

Change the file ending back to .xls, open the file, enable macros, then try renaming the file to the new extension.

Posted on Mar 15, 2008

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 am using microsoft excel 2007, the code is not running, the macro was disabled.. How to enable the macro...?


From the excel help file

  1. Click the Microsoft Office Button o12filemenubutton_za10077102.gif, and then click Excel Options.
  2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
  3. Click the options that you want:
    • Disable all macros without notification Click this option if you don't trust macros. All macros in documents and security alerts about macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system.
    • Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.
    • Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.
    • Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.
    • Trust access to the VBA project object model This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box.

Jun 21, 2011 | Microsoft Office Professional 2007 Full...

Tip

Keyboard shortcuts for Microsoft Windows XP, Vista, 7 and Microsoft Office


Windows

Windows Key+E
This shortcut allows you to open Windows Explorer with one quick keystroke.

Alt+Tab
This allows you to easily toggle back and forth between all the windows you have open. You can also use this to switch between windows in the same program, making multitasking real easy.

Windows key+Tab
This lets you scroll the items on the taskbar, and in Vista, it starts Flip 3D for a fun graphical spin on the same idea.

Alt+F4
This shortcut is a quick way to close a window in any program without using your mouse to hit the X in the upper-right corner.

Windows Key+M
This allows you to minimize all of your open windows, leaving just the desktop left exposed. To restore the windows, hit Windows key+Shift+M. Another quick way to do this is Windows key+D, which shows your desktop; to restore, just repeat the same keystroke.

Ctrl+Drag
There are many ways to copy a file, but this just might be the easiest. All you have to do is click on the file, hold, and drag it into its desired location. This works the same as another handy shortcut, Ctrl+C.

Windows Key+U+U
This is the shortcut for quickly shutting down Windows by hitting the Windows key (don't hold it down), hitting U to reach the shutdown menu, and then hitting U again to shut down.

Windows Key+Pause
This is a quick way to get to the Systems Properties menu.

Shift+Delete
If you want to delete a file-and you don't want to deal with it later in the Recycle Bin-this is the way to go. Just be absolutely sure that this is a file you won't want back!

To bypass the Autorun when inserting a CD
Hold Shift While Inserting the CD.


Microsoft Office

Ctrl+U, Ctrl+B, Ctrl+I
Used to snap to underline, bold, and italicize without the mouse if you press Ctrl+U (underlining), Ctrl+B (bolding), or Ctrl+I (italicizing).

Shift + Arrow Keys
Holding shift and pressing one of the arrow keys will highlight text in Word (or a group of Excel cells) without the mouse, selecting in the direction the arrow points.

Ctrl+Z, Ctrl+Y
Undo an action by hitting Ctrl+Z; if you change your mind, Ctrl+Y will redo the undo.

Microsoft Office - Excel

F1
Opens a help task pane

F1 + Ctrl
Opens or closes the help window
F2
To edit the text in the active cell
F2 + Shift
To write a comment in the active cell

F2 + Alt
Opens the save as dialog box

F3 + Shift
Opens the insert dialog box

F3 + Ctrl
Opens the define name dialog box

F3 + Shift + Ctrl
Opens the create name dialog box

F4
To redo the last command

F4 + Ctrl
To close the workbook window

F4 + Alt
To close the excel program

F5
Opens the Goto dialog box

F5 + Ctrl
brings back to the first level of workbook

F6
To shift between help taskbar and the excel window

F6 + Shift
To goto the previous square in the open worksheet

F6 + Ctrl
If more than one workbook is open to switch between them

F7
To open spelling correction window

F7 + Ctrl
When workbook window is not maximised it will move the window

F8
To activate / deactivate extended mode

F9
Will calculate all the worksheets in all open workbooks

F9 + Shift
Will calculate the active worksheet

F9 + Ctrl
To Minimise the workbook window

F10
Will select the menu bar

F10 + Ctrl
To open minimised window

F11
Will create a chart using the current range

F11 + Shift
To select a new worksheet

F11 + Alt
To switch between visual basic editor and the worksheet

F11 + Alt + Shift
Opens microsoft script editor

F12
Opens save as dialog box

F12 + Shift
Saves the active workbook

F12 + Ctrl
To open the Open dialog box

F12 + Ctrl + Shift
Opens the print dialog box

on Jan 01, 2011 | Computers & Internet

2 Answers

I want to know about macros


you can find more information about macro and usage of macro from
Automate computer tasks easily with macro software

Oct 29, 2010 | Computers & Internet

1 Answer

Same problem - excel files balllooning from 20Kb to 45Mb


This could happen if your workbook is being shared.
1. Make a backup copy of your workbook (Excel file).
2. Open it in Excel
3. Check under Tools > Share Workbook and see if the "Allow changes by more than one user..." option is selected. If so, try unchecking it and save the workbook
4. Check the file size under File > Properties > General tab


Another possibility is that there are a lot of unused cells with "invisible" formatting. To check that you can try pressing Ctrl+End and see where the end of your document is. If it is way beyond your current work area, select those extra columns and rows and go to Edit > Clear > All (Note: This will delete everything on those cells)


Aug 19, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Problem w/ Nikon D40...Help Plz *_*


check your camera's shutter speed then try shooting again. set it to different modes, try manual, increase the shutter speed to 80. don't use flash shoot in daylight. try that first... see if its still blurred. hit me back on the results.

Apr 28, 2009 | Nikon D40 Digital Camera with G-II 18-55mm...

1 Answer

Macros with expired signature.


go to tools->options->security
click on "macro security" button
change security level to "medium" or "low".

be aware that low security on macros means viruses can attack your computer through word documents. don't leave it on that setting for too long.

Dec 08, 2008 | Computers & Internet

1 Answer

Macros


After you record your macro do the following.
Open the excel file contains the macro. Go to tools and go to macro and click on macros. Select the macro you wish to add the close operation. Click on Step into... This will open up the visual basic editor. In the code window, at the bottom row you will see End Sub. Right before that row, type workbooks.close
Save the macro by clicking the save button. And you can run your macro to see if it works. I tried, it does :) Good Luck :)

Aug 18, 2008 | Microsoft Excel for PC

1 Answer

Macro


Hi motilal

Follow these steps to create multiple macros

Click the Microsoft Office Button , and then click Excel Options.
In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

Note The Ribbon is a component of the Microsoft Office Fluent user interface.
To set the security level temporarily to enable all macros, do the following: On the Developer tab, in the Code group, click Macro Security.


In the Macros Settings category, under Macro Settings, click Enable all macros (not recommended, potentially dangerous code can run), and then click OK.

Note To help prevent potentially dangerous code from running, we recommend that you return to any of the settings that disable all macros after you finish working with macros.
Open the workbook that contains the module that you want to copy and the workbook that you want to copy the module to.
On the Developer tab, in the Code group, click Visual Basic.
On the View menu, click Project Explorer .
Drag the module that you want to copy to the destination workbook.

Regards,
TheAssembler

May 06, 2008 | Microsoft Excel for PC

2 Answers

MS EXCEL 2000 corrupted workbooks/worksheets


it sounds like you are going over the limits of the program these are the specs. I would recommend dividing up the data if you can. or moving it to a database that can act like excel and hold more data.

Apr 29, 2008 | Microsoft Excel for PC

1 Answer

EXCEL


I have solution for your second problem.
You just need to use macros to protect all the sheet at the same time. Just open "Macro>Record new Macro" to insert new macros to your files.

This will save some your valuable time.

Jan 09, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Excel for PC Logo

93 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...