Computers & Internet Logo

Related Topics:

G
Graeme Thomas Posted on Feb 27, 2017
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Using a WPS Spreadsheet with embedded macros. How do I enable macros please. Thx. Graeme

1 Answer

dagem aberham

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.

Guru:

An expert who has written 7 tips or uploaded 3 video tips

  • Expert 123 Answers
  • Posted on May 20, 2019
dagem aberham
Expert
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.

Guru:

An expert who has written 7 tips or uploaded 3 video tips

Joined: Jun 04, 2011
Answers
123
Questions
4
Helped
52723
Points
604

Enable macros in the Backstage view Another method to enable macros in a file is via the Microsoft Office Backstage view, the view that appears after you click the File tab, when the yellow Message Bar appears. Click the File tab. In the Security Warning area, click Enable Content. Under Enable All Content, click Always enable this document's active content. The file becomes a trusted document.

2 Related Answers

Anonymous

  • 58 Answers
  • Posted on Nov 20, 2007

SOURCE: Game Embedded In Excel 2007 Won't Play

You are better off not playing the game as they usually contain some form of malware.

To possibly infect yourself you by playing the game will need to change the security settings for macros in excel. This is usually located in the Tools menu. Set it for the least restrictive setting, but you have been warned, you will be infected with malware. If not with this game then in the near future.

Ad

Anonymous

  • 643 Answers
  • Posted on Jun 21, 2011

SOURCE: i am using microsoft excel

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.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer

Where to find wps pin on canon mx494 printer

Hi Mbali, PIXMA MX494 Wireless Connection SetupSome access points (sometimes referred to as routers or hubs) feature an automatic connection button labelled "WPS" which stands for Wi-Fi Protected Setup.This allows permitted devices such as your PIXMA MX494 to connect to your network without needing to enter a password and it enables a quick and easy method of connecting your devices.This method is by far the easiest way of connecting your PIXMA MX494 so if your access point has a WPS button please select the 'WPS Connection Method' tab below for instructions on connecting using this method.If your router does not support WPS we have provided alternative instructions to get your PIXMA MX494 connected so please select the 'Standard Connection Method' tab below.Back to topWPS Connection Method Standard Connection Method Restore to Factory SettingWPS Connection Method Before we start, there are some conditions that must be met in order to use the WPS push button method:The access point must have a physical WPS push button available. Please check with your device's user guide for details. If the WPS push button is not available please use the instructions on the Standard Connection Method tab.Your network must be using the WPA (Wi-Fi Protected Access) or WPA2 security protocol. Most WPS enabled access points use this protocol.Press the [Setup] button (B) on the printer. Use the arrow buttons (C) to select [Device settings] and press the [OK] button. Use the arrow buttons (C) to select [Wireless LAN setup] and press the [OK] button. The printer will now automatically search for access points supporting the WPS feature. The following message will be displayed on the printer's screen "Press WPS button of the wireless router about 5 sec. and press [OK] on this printer" Press and hold the [WPS] button on your access point for approximately 5 seconds, then release. For exact instructions on starting WPS on your access point, please refer to its user guide. Press the [OK] button on the printer within 2 minutes. Once connected, the following screen will appear. Press the [OK] button to complete the setup.
Thanks
1helpful
2answers

I am trying to connect my canon pixma 452 printer to my samsung tablet. Where is the WPS button ?

WPS Connection Method Before we start, there are some conditions that must be met in order to use the WPS push button method:
  • The access point must have a physical WPS push button available. Please check with your device's user guide for details. If the WPS push button is not available please use the instructions on the Standard Connection Method tab.
  • Your network must be using the WPA (Wi-Fi Protected Access) or WPA2 security protocol. Most WPS enabled access points use this protocol.
Step 1 1. Press the [Setup] button (A) on the printer.
Step 2
1. Select [Wireless LAN setup] and press the [OK] button.
The blue Wi-Fi lamp (A), will light up when the wireless connection is enabled.
The printer will now automatically search for access points supporting the WPS feature
Step 3
The display on printer should be as shown below:
(The message will read: "Press WPS button about 5 sec. and press [OK] on the device)"
1. Press and hold the [WPS] button on the access point.
For exact instructions on starting WPS on your access point, please refer to its user guide.
2. Press the [OK] button on the printer within 2 minutes.
The blue Wi-Fi lamp on the printer flashes while searching for or connecting to the access point.
Once connected, the following screen will appear. Press the [OK] button.
If another screen appears, please refer to "troubleshooting" in the user guide.
This concludes the WPS setup procedure.
Please now proceed by installing the software to make the most out of your PIXMA MX474.
  1. If you do not have the installation CD that came with your product, please download the manuals and software.
If the WPS wireless setup is still failing after following this guide, please Contact us for further assistance. 1 888 224 4280
0helpful
1answer

Can you move a document from wps writer to wps spreadsheet to alphabetize

HI,

As they are free programs they are sometime limited in their functions. Other than doing a select all then copying it from the doc then pasting it into a sheet ..
0helpful
1answer

Trying to install Brother HL-2130 wireless printer. The install process is asking for WPS pin number. I dont have any manuals and dont know what this number is? Can anyone help please.

The wps pin method is bit tricky however it will help you get the work done. you need few details upfront in order to connect brother printer with wifi using wps pin method. details such as -
  1. Your router must be an wps Enable Router that support WPS Pin method
  2. default router details such as default ip address or web address to access the portal
  3. Router admin username and password
To read more please visit WPS Pin method to setup Brother Printer
https://brotherprinterwifisetup.com/blog/how-to-connect-brother-printer-to-wifi/
0helpful
1answer

Where is wps on Belkin n1 vision?

Before you will be able to use this function, you will have to log into your router and enable WPS push button in the security settings.

Using Wi-Fi Protected Setup
WPS uses WPA2 (described below) for encryption. It does not
provide additional security, but rather, standardizes the method for
securing your wireless network. You may use either the Push Button
Configuration (PBC) method or PIN method to allow a device access to your wireless network. Conceptually, the two methods work as follows:
PBC: Push and hold the WPS button located on the back of your N1
Vision for three seconds. Then, initiate the WPS procedure on the client device within two minutes. Refer to your client's documentation on this procedure. Pushing the PBC button will automatically enable WP
1helpful
2answers

What is exel sheet extension in office 2010 ?

Excel Workbook

.xlsx

The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook

.xlsm

Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template

.xltx

The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template

.xltm

Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In

.xlam

A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

1helpful
2answers

Whenever I open a new spreadsheet now it automatically opens up a spreadsheet calles PERSONAL. Why is that and how can I get rid of it... I think it started after a did a macro but I am not sure. Thanks,...

You're right - it was caused by recording a macro. When you record a macro you are given the option to store the new macro in "This Workbook", a "New Workbook" (the default), or in a "Personal Macro Workbook". It looks like you selected "Personal Macro Workbook".
The recorded macro is stored in a special workbook called "Personal.xls". This workbook is loaded every time Excel is loaded. If you don't want this workbook loaded, then just delete it or rename it.
The file is buried deep in Microsoft's application data area. On my Vista computer it's in C:\Users\frogfund\AppData\Roaming\Microsoft\Excel\XLSTART On my Windows XP computer it's in C:\Documents and Settings\frogfund\Application Data\Microsoft\Excel\XLSTART. Depending on your computer your Personal.xls might be in a slightly different location. You might need to do a search using Windows Explorer.
If you are still having troubles finding personal.xls 1. Open Excel, 2. Open the Visual Basic editor (hit Alt-F11 or click Tools-Macro-Visual Basic Editor) 3. Click Tools-References to bring up the references dialog 4. Click on VBAProject in the list. The file location will be displayed near the bottom of the dialog box. Sometimes this might be cut off at the end, but it should give you a good idea where the file is located. 5. Click Cancel to close the dialog.
0helpful
2answers

Game Embedded In Excel 2007 Won't Play

You are better off not playing the game as they usually contain some form of malware.

To possibly infect yourself you by playing the game will need to change the security settings for macros in excel. This is usually located in the Tools menu. Set it for the least restrictive setting, but you have been warned, you will be infected with malware. If not with this game then in the near future.
0helpful
1answer

Macros Command Help

Your Excel may have a different "Macro Security" setting. Your "Macro Security" can be adjusted: Tools, Macro, Security. I highly recommend the "Medium" setting. This will prompt you when an Excel file is opened that contains Macros to Enable or Disable. If you choose a security setting of "Low" please be very careful as this will allow Macros to run without any notice, VERY DANGEROUS.
Not finding what you are looking for?

16,803 views

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6687 Answers

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

Answer questions

Manuals & User Guides

Loading...