Security Warning When Workbook Opened

May 30, 2009

my workbook is finally working the way it should but every time i open it i get a security warning window with the options disable macros, enable macros and more info. how do i get this to not show up every time it's opened. this workbook will be used by someone other than me and i don't want them to need to do anything but open it and use it.

View 8 Replies


Security Warning (Macros Have Been Disabled)

Apr 28, 2008

I was playing around with Macros on an excel file. I created a few and ran them. In the end, I didn't like the way they ran, so I deleted them all. However since I ran them in the excel file, every time I open the file it gives me a warning saying
"Macros have been disabled."

Is there any way to remove the possible Macros ties/links from my file? I know I can disable the warning, but if I just want to remove the Macros ties to my file.

View 10 Replies View Related

Turn Off Security Warning Regarding Macros

Jun 2, 2009

I would like the security warning not to pop up when the workbook is opened. I have been able to turn it off for myself but I had someone else test it and each time it's opened the security warning pops up with the disable, enable messages. Is there a way to turn this off permanently so not matter who opens it it won't pop up?

View 9 Replies View Related

Security Warning About Macros When Opening 2003 File

Mar 3, 2009

I'm using Excel 2003 and recently when I open a file, it prompts out a Security Warning message about Marcros which at the end contains 3 choices: Disable Macros, Enable Macros, and More Info. I then click Enable Macros to open the file. Once open, I go to Tools > Marco > Run Marco (Alt+F8). A Macro box prompt out but the Macro list is empty. I try different choice inside the pull down menu "Macros in" but the Macro list is still empty.

Where can I find out the macro which triggers the warning message of Security Warning when opening the file? And how can I delete the macro if found useless.

View 7 Replies View Related

Macro To Delete Vba Code - Macro Security Warning

Feb 7, 2008

I have recently grabbed the very helpful "Macro to delete VBA code" from this site, and it's working but with one small problem.

My worksheet runs a lot of code, then deletes all macro code and saves itself.

The problem is the next time i open I still get the macro security warning!

I've checked thoroughly and there is definatley no vba left anywhere.

If I open the document, enable macros, and save it, then open it again, I no longer get the warning.

View 9 Replies View Related

Copy A Range Of Cells In Another Workbook Opened In A Separate Instance Of Workbook

Feb 11, 2010

I m not able to use the standard Excel Paste Special function when I copied a range of cells in another Excel workbook opened in a separate instance of Excel. Instead, Paste Special thinks that I have copied some non-Excel objects and gave me the Paste As options. This is not the case if I open both workbook within the same instance of Excel. Could you share with us if there is a trick to trigger the normal Paste Special options in such situations (without having to invoke Macro procedures)?

View 2 Replies View Related

Copying Data From Recently Opened Workbook To Workbook Where Form Is Present

Jun 16, 2014

All i did was i just created a form to open a workbook from the directories.

Code to copy the data from that recently opened workbook to my workbook where I have my forms. I need to copy that data as in the case that i don't know the workbook and the sheet name i'am going to open as i may open any of the files!!

View 2 Replies View Related

Copy Worksheet From Closed Workbook To Current Opened Workbook

Aug 21, 2014

I have an open workbook (A) and this is where the code should reside. I want to use VBA to copy the content of an entire worksheet from a closed workbook (B) to an existing worksheet in workbook A. How would you accomplish this?

View 7 Replies View Related

Automatic Open Others Workbook When We Opened The Master Workbook

Aug 26, 2009

How to Automatic open others Workbook when we opened the Master Workbook.
Examp.: I have a workbook (Master.xls), and when this file be opened, and then others workbook (Transactions.xls, Order.xls, etc.) is opened too.

View 5 Replies View Related

Active Workbook Refreshall Security

Nov 4, 2008

I have a function that is called in Access vba code that refreshes all sheets in a given workbook. We use it all the time for workbooks containing any number of tabs to be refreshed. The code has a key line: ActiveWroksheet.Refreshall. I need to now start to secure the pivot so the user can not refresh it. Another post pointed me towards: .PivotCache.EnableRefresh = False.

This apparently can only be used for a particular sheet; ie it can not be applied to ALL sheets in the workbook. The trouble is the function is generically used to refresh any workbook, and the number of sheets may vary.

Any thoughts on how I can disable the ability to refresh a pivot for ALL sheets. I'd prefer not to turn off the pivot wizard since the user should be allowed to manipulate it...just not refresh it.

View 9 Replies View Related

VBA Warning For Misplaced Workbook ...

May 7, 2007

I have one excel workbook (called “workbookA”) stored on network device (hard drive with its own ip address). The idea is not to allow users to save that excel workbook locally on individual pcs; otherwise, others wont be able to see updates done by a particular user that saved the workbook on his or her computer (regardless of intention).
The idea I have is to have a second workbook (called “workbookB”) on the same network drive; and cell $A$1 of this workbookB is being referenced by workbookA.

$A$1 cell of workbookB has value of ‘20’. And, cell A8 of workbookA refers to that cell

My code below checks the value of A8 cell of workbookA against the value of $A$1 cell of workbookB has value of ‘20’. If the values do not match, cell A9 of workbookA displays “Unauthorized Copy”. (One can even elect to have the VBA code to overwrite all cells - thus destroying the workbook.)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("$A$8") "'[NO_NO.xls]SHEET00'!$A$1" Then
' places "Unauthorized Copy" to Cell $A$9
Application.EnableEvents = False
Application.ScreenUpdating = False
Sheets("FID").Unprotect Password:="password"
Range("'[FID.xls]FID'!$A$9").Value = "UNAUTHORIZED COPY"
Sheets("FID").Protect Password:="password"
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub

I feel embarrassed, but this is the best idea I’ve got. Plus I am getting "Run-time error '1004'; Method 'Range' of object '_Worksheet' failed" & whenever the workbook is being opened, excel asks is the links (referenced) are to be updated or not (whole another story). Are there any simpler & more interesting ideas to ensure that the user gets alerted whenever the workbookA is removed from (saved in a location other then) the network device?

View 9 Replies View Related

Real Security For Excel - Protect Workbook

Oct 5, 2013

I have a workbook which i really want to protect. I don't want any formulas to be seen and tampered with.

Simply hiding/locking cells and protecting the sheet is not secure enough. within minutes of googling crack password, i was able to find a macro that unlocks the sheet.

Is there something out there that can really secure your workbook. I found something called XLS Padlock [URL].... seems great.

View 2 Replies View Related

Making Workbook Opened From Other Workbook Active

Nov 20, 2006

I have a workbook that is a formatted report that I need to insert data from a name variable "CSV" file. I have created a macro in this workbook that calls an "Open" dialog for CSV files that I can use to browse to and open the source file. The macro then is supposed to "select all" copy and close the workbook then make the original workbook active and paste the data starting at row 2. The macro "seems" to be working perfectly except when I do the open the macro then makes the original workbook active, selects all copies then wants to close the original workbook. How can I tell the macro that the csv file that I just opened should be the active workbook, baring in mind that the name won't be known before the time it's opened so I can't hardcode the "active. workbook (NAME) "route.

View 9 Replies View Related

If Macros Are Diabled At Security Prompt, How To Prevent Workbook From Opening

Dec 15, 2008

I am relying on macros for a lot of functionality and security.

Is there a way to stop a spreadsheet from being opened/accessed if a user disables macros at the security prompt?

View 9 Replies View Related

How To Save Workbook With Macros Without Warning Message

Oct 3, 2013

I have several workbooks that use macros from my personal macro library (MyExcelAddIns.xlam).

Some of these, especially new ones, get an error message every time I save them: "Privacy warning: This document contains macros, ActiveX controls, ... These may contain information that cannot be removed by the Document Inspector."

Then after I save it once or twice, the message goes away. Why am I getting this message? Why only sometimes? What can I do to get rid of it entirely?

View 3 Replies View Related

Run Macro Once Workbook Is Opened

Oct 2, 2012

I want my macro on the IR Tracker sheet to run once workbook is opened. Is this possible?

I have attached the workbook for better understanding.

View 9 Replies View Related

Set Reference To NOT OPENED Workbook

Dec 18, 2008

I've started this thread a few weeks ago but didn't get any answers on how to solve the problem or if it was even possible to solve. I would like to know if is possible to set a reference to a NOT OPENED workbook. All the code I've tried so far didn't get me anywhere:

View 3 Replies View Related

Zoom To 120 When Any Workbook Is Opened?

May 13, 2014

I am looking for a way to have Excel zoom to 120% whenever any workbook is opened. (My boss has poor eye sight...)

I set up a simple Macro

Sub Auto_Open()
ActiveWindow.Zoom = 120
End Sub

but I get an error that says "Run-time error '91': Object Variable or With block variable not set.

View 1 Replies View Related

Determine How Workbook Was Opened

Sep 8, 2006

Is it possible to write code that can identify how a workbook has been opened i.e. has the workbook been opened by another workbook or has it received a double click event on the workbook itself.

If it is possible I would like to place the code in the open event of the workbook that is being opened.

View 5 Replies View Related

Run Macro In Opened Workbook

Oct 31, 2006

An external program opens and closes Excel Workbook (OLE). What is the VBA code so when the WB is opened, Macro1 will run before OLE closes that Workbook?

View 6 Replies View Related

Loop Until The Workbook Is Opened

Jan 4, 2008

i'm tyring to formulate a do loop that will basially loop until the workbook is opened. here is my code...

Dim myBook As Workbook

On Error Resume Next
Set myBook = Application.Workbooks(vCriteria & "ISPR.XLS")
On Error Goto 0

what i want is for it to loop until myBook is <> nothing... but i'm not sure how to do that.

View 5 Replies View Related

Return To Certain Tab Each Time Workbook Is Opened

Nov 10, 2009

I have an excel file on a share site which is accessed by several people. The first tab is set up as a home page which directs the person to the relevent part of the work book that they need. My problem is that as the person saves their updates it also saves the location of the workbook they were in. I want it to return to the " homepage" automatically each time it is opened.

View 5 Replies View Related

Listbox Freezes When Workbook Is Opened

Apr 30, 2014

I have a little issue with a list-box. When i open my workbook and i click on the List Box the list box freezes, excel doesn't let me select it until i go to design mode, select the list box then close out of design mode. This sort of "fixes" the issue but i would rather not do so this way.

View 2 Replies View Related

Cells Dependent Upon How Workbook Is Opened

Jun 9, 2009

I have a workbook with about 30 tabs in it. It is currently protected by a password. The workbook itself has a couple of 1000 formulas across the tabs.

What I would like to do is to lock certain cells on each worksheet depending upon if the workbook is opened as "read only" or "in edit mode" (when someone uses the password).

So when someone uses the correct password, I would still like certain cells to be locked, or after the initial password is entered for editing, another popup box with "would you like to edit cell formulas? Y/N (only on selective cells), if no, then no editing on those cells allowed, if yes, then prompted to input another password to do this.

View 14 Replies View Related

How To Automatically Run VBA Code When Workbook Is Opened

Aug 10, 2010

How do I automatically run VBA code when a workbook is opened?

View 7 Replies View Related

VBA To Count How Many Time A Workbook Is Opened

Oct 27, 2010

Just wanted to ask all the VBA gurus if they would know how to put the number of times (i.e. in Sheet 1, Range A1) a Workbook is opened.

I then want to basically have the code delete every sheet if ithe count is > 50.

View 7 Replies View Related

Jump To Date When Workbook Opened?

Jan 24, 2013

Is there a way that when the workbook is opened, it automatically jumps to the sheet that has today's date on it and highlights that cell.

I have 12 sheets, one for each month and labeled as such. The dates for each month in cells D5:AH5 on each sheet.

View 6 Replies View Related

Update Cell When Workbook Opened

Dec 18, 2008

How can I ensure that a cell (A1) is defaulted to the current date each time the file (in which the cell resides) is opened.

A1 is a field of a form in which the user can enter a date. I would like it to default to the current date each time the file is opened.

View 9 Replies View Related

Workbook To Check It Filename Once Opened

Dec 29, 2009

I am trying to ensure that m work book keeps the same name even when I email it to others.

I have been told on this forum that it is possible for a workbook to check its own name once opened?

I have two different names that this file can be called 1st is the one that is in use all the time and the 2nd is a archive version where the name changes each month.

The file name I wish to keep the same for the no archived version is Toolbox and a predetermined number I have a workings sheet called workings and in a cell i have a formula =TEXT("Toolbox Application " & Cover!E10,) this will give me the file name that i need to check for example it could be Toolbox Application 00089 or Toolbox Application 00967.

I also have a cmd that archives the workbook and saves it as Toolbox and the Month it was for Toolbox for Jan for example

I also need this to open if it is an archive

if neither of the names match i need the workbook to close and a msgbox to tell user to rename the workbook correctly.

View 9 Replies View Related

Copy Cell To Other Opened Workbook

Apr 20, 2006

iam trying to populate another open workbook worksheet with the iformation inputed into the the InputBox

Private Sub Workbook_open()
MsgBox "Welcome to THE ESTIMATOR, Provide by Brisbane Marketing and Estimating Services!", 64

' If sheet was named by original open routine, exit

If ActiveSheet.Name = "Main Roof" Then Exit Sub

' otherwise


View 4 Replies View Related

Copyrights 2005-15, All rights reserved