Free Microsoft Excel 2013 Quick Reference

Excel 2007 and security Warning (macros disabled)

I just upgraded to 2007 and write a lot of macros and VBA code. I am noticing that each time I open a spreadsheet, macros have been disabled and I have to click on Options to "enable Content". Is there a way to enable this all the time without having to go through the motions every time?

Thanks


I've instilled Excel 2007 on several PCs and written lots of macros in Excel 2007, and never had any problems. Today I installed Excel 2007 on a new PC. I've set macro security to enable all macros, and added the developer tab to the toolbar. However anything to do with VBA - record new macro, visual basic editor etc - is greyed out, as if I hadn't set the security option. I've closed and repoened Excel and the option is still set, but it won't let me create new macros. Have I forgotten another setting somewhere?

Thanks

(Vista Premium, McAfee Internet Security installed - hate the product, doesn't have any obvious way of disabling all functions quickly)

Hey guys, I'm sure this is a silly question, but if there's anyone who could walk me through this, I would immensely appreciate it!

I have this macro that I'd assigned a custom button to in Excel 2003, but I did it so long ago I can't remember how.

I just moved to Excel 2007, and I'm not sure how to (1) create a custom button and then (2) associate it with this macro so it can be used in all documents. I don't even know where to save the macro anymore or how to create it.

Here's the original macro. It should still work, right? Thanks so much for any help!

Sub InsertRow()
If Selection.Row

Hello Forum,

I am coming to you regarding a small problem on a macro.
This macro is made to insert pictures in a cell automatically after double click. It resizes the pic according to heigh and width of the cell. Very usefull macro in fact :-)
This macro works very well with excel 2003.
Now am shifting to excel 2007 and noticed that macro still works. insertion of pictures is still happening.
But once inserted and while sorting out the excel sheet it appears that pictures wont move.
I hope someone has the solution to this.
Thanks in advance

the script is as follow and i am attaching the file as well

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Application.Dialogs(xlDialogInsertPicture).Show

With Selection
.ShapeRange.LockAspectRatio = msoFalse
.Width = Target.Width
.Height = Target.Height
.Placement = 1
.PrintObject = True
End With

End Sub

Hello Everyone,

I currently have about a bazzilion usernames and passwords for various programs, log-ins, websites etc. I was considering creating a password database in Excel to store all my password details and using the built-in password protection to secure/hide the details so only I can see/access them. I have Excel 2007 and was wondering how secure the password security is. I've heard that the older versions weren't very secure and could be easily hacked but that Excel 2007 is a lot better in terms of security.

With regards to the type of passwords I'd be keeping in the database it wouldn't be anything vitial (no online banking details for instance) - it would be mostly things such as website usernames and passwords.

Best regards
-Rob

Building Excel 2007 and Excel Services Dashboards by Consuming Two ...

... Office system (version 3.0) for Excel 2007, and how to create user-defined functions for ... This database represents a system that requires a separate logon and contains sales ...

Building Excel 2007 and Excel Services Dashboards by Consuming Two ...

Microsoft Office SharePoint Server 2007 introduced a new technology for ... for the Microsoft Office system (version 3.0) for Excel 2007, and how to create user-defined functions ...

Hi

I have just been upgraded to Excel 2007 and whilst there are some very useful features I am somewhat dismayed that there are old features that are no longer supported.

Specifically, I want to create a data validation statement that allows the contents of a list and dynamically adjusts itself to the length of the list. In the good old days I created a Names Range, defining the range by =OFFSET($AA$1,0,0,COUNTA($AA:$AA),1) for example and then referenced that name in the data validation statement.

Looking at some of the blurb on the Excel pages it appears that Excel 2007 no longer supports named ranges. My question, therefore is twofold:

1 How can I achieve the same in Excel 2007, and

2 Can I save a workbook created in Excel 2007 and preserve this functionality for earlier versions?

Many thanks

I am running both Excel 2007 and Excel 2003 on the same computer. There is no Add-In tab in Excel 2007 even though I have enabled several add-ins within Excel 2007. I was wondering if running both versions may be causing this? Thank you.

Help! Excel 2007 and Excel 2003 are not compatible?

Hi all,

I just don't understand this.

I have a Excel sheet which was created in Excel Xp 2003. And it is
full of calculations.

When I open it in Excel 2007,

And press SHIFT+F9, it always gives "NO-CELL" error.

Basically it doesn't run at all.

But when I go to each cell, and following the logical dependency, and
refresh/recalculate each cell one by one,

then the results are correct...

But there are so many cells and manually going through them are
infeasbile.

What can I do now?

Can anybody help me?

Thanks!

I am trying to load and Excel spreadsheet within the IE7 browser window and
instead of getting it within the browser window I get the spreadsheet in an
Excel 2007 window. In XP there is an option in Explorer tools->Folder Options
an the .XLS extension to display in browser option. Vista does not have this.
How can I still do this with Excel 2007 and Vista?

Thanks

Running old .xla routines in Excel 2007, and "VBA converters"

I am trying to run .xla routines from a 2003 book* in Excel 2007. Upon starting Excel 2007, I get the error message "Opening the VBA project in this file requires a component that is not currently installed. This file will be opened without the VBA project. For more information, search Microsoft Office Online for 'VBA converters'." Then this message appears, "Excel was able to open the file by repairing or removing the unreadable content. This workbook has lost its VBA project, ActiveX controls and any other programmability-related features. I have searched all over the Microsoft site and the net in general for the elusive "VBA converters", but all I find is alot of complaining about their lack of availability.Do you think that "VBA converters" are what I need, or is there another possible solution?Thanks for your help.*'Decision Making with Insight' by Sam L. Savage

Hello Guys,
Will be pasting the VBA code below which is working correctly in excel 2003 but it is not working in excel 2007 and excel 2010.
Found the reason that Application.Filesearch has been deprecated in 2007 and 2010.

Need your help in modifying the code below

	VB:
	
) 
    Dim filenum As Integer 
    FindFiles = 0 
     
    With Application.FileSearch 
        .NewSearch 
        .LookIn = searchDir 
        .SearchSubFolders = True 
        .fileName = searchFile 
        If .Execute() > 0 Then 
            FindFiles = .FoundFiles.Count 
            For filenum = 1 To .FoundFiles.Count 
                FileList(filenum) = .FoundFiles(filenum) 
            Next filenum 
        End If 
    End With 
End Function 
[B][/B] 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Thanks,
Prakash N

SharePoint 2007 Sample: User-Defined Functions for Excel 2007 and Excel Services Sample Solution

The SharePoint 2007 Sample: User-Defined Functions for Excel 2007 and Excel Services Sample Solution contains sample user-defined functions (UDFs) and supporting files.

I have a Userform that I created in Excel 2007 with a Calendar. When I open this in Excel 2010, the Calendar isn't part of that version, so the object is removed from the Userform and I am forced to comment out the calendar script.

I have heard about the Date Picker, but I have no idea how to use it.

Is there a tool I can use to allow the Calendar to come up when the Userform is opened with Excel 2007 and the Date Picker when the program is opened using Excel 2010?

This calendar allows the user to select a date and then the information is passed to a cell where the date is filled in.

I need the script to be versatile between the two and I'm racking my brain trying to figure this out.

Any advice or direction is greatly appreciated. I have no idea where to start when trying to combine the two date options.

Here is what I've done so far on my own... My mind is very scrambled... Please help!

Private Sub cboEnrollmentAdvisor_Change()

End Sub

Private Sub cmdClearForm_Click()
    Call UserForm_Initialize
End Sub

Private Sub cmdCancel_Click()
    Unload Me
End Sub

Private Sub cmdOK_Click()
Dim NR As Long

'transfer values to database
    With ActiveWorkbook.Sheets("November2011")
        NR = .Range("A" & .Rows.Count).End(xlUp).Row + 1
        .Range("B" & NR).Value = txtFName.Value
        .Range("C" & NR).Value = txtLName.Value
        .Range("D" & NR).Value = txtIRN.Value
        .Range("A" & NR).Value = cboEnrollmentAdvisor.Value
        .Range("E" & NR).Value = frmCalendar.Value
    End With

'Reset values
    txtFName.Value = ""
    txtLName.Value = ""
    txtIRN.Value = ""
    cboEnrollmentAdvisor.Value = ""
    frmCalendar.Value = ""
End Sub

Private Sub cmdSubmit_Click()

End Sub



Private Sub TextBox1_Change()

End Sub

Private Sub CommandButton1_Click()
    Unload Me
    ActiveCell.Select
End Sub
Private Sub MonthView1_DateClick(ByVal DateClicked As Date)

    ActiveCell = MonthView1.Value
    Unload Me
    ActiveCell.Select

End Sub
Private Sub UserForm_Activate()
    If Not IsDate(ActiveCell.Value) Then
        Me.MonthView1.Value = Date
    Else
        Me.MonthView1.Value = ActiveCell.Value
    End If
End Sub
Private Sub UserForm_Initialize()
    Dim frm As Long, frmstyle As Long
    If Val(Application.Version) >= 9 Then
        wHandle = FindWindow("ThunderDFrame", Me.Caption)
    Else
        wHandle = FindWindow("ThunderXFrame", Me.Caption)
    End If
    If wHandle = 0 Then Exit Sub
    frm = GetWindowLong(wHandle, GWL_STYLE)
    frm = frm Or &HC00000
    SetWindowLong wHandle, -16, frmstyle
    DrawMenuBar wHandle

    With Me
     .Left = ActiveCell.Offset(0, 1).Left
     .Top = ActiveCell.Top + ActiveCell.Height + 15
     .StartUpPosition = 0
    End With

End Sub



Private Sub Image1_Click()

End Sub

Private Sub Label9_Click()

End Sub

Private Sub Degree_Initialize()
    txtFName.Value = ""
    txtLName.Value = ""
    txtIRN.Value = ""
    With cboEnrollmentAdvisor
        .AddItem "********************************************Undergraduate
Degrees*******************************************"
        .AddItem ""
        .AddItem "Bachelor of Science in Early Childhood Education (Leads to Credential)"
        .AddItem "Bachelor of Science in Elementary Education and Special Education (Dual Major) (Eligible for
Institutional Recommendation)"
        .AddItem "Bachelor of Science in Elementary Education Grades K-8 (Emphasis in Early Childhood Education)
(Eligible for Institutional Recommendation)"
        .AddItem "Bachelor of Science in Elementary Education Grades K-8 (Emphasis in English) (Eligible for
Institutional Recommendation)"
        .AddItem "Bachelor of Science in Elementary Education Grades K-8 (Emphasis in Math) (Eligible for Institutional
Recommendation)"
        .AddItem "Bachelor of Science in Elementary Education Grades K-8 (Emphasis in Science) (Eligible for
Institutional Recommendation)"
        .AddItem "Bachelor of Science in Secondary Education (Emphasis in Business Education) (Eligible for
Institutional Recommendation)"
        .AddItem "Bachelor of Science in Secondary Education (Emphasis in English) (Eligible for Institutional
Recommendation)"
        .AddItem "Bachelor of Science in Secondary Education (Emphasis in Math) (Eligible for Institutional
Recommendation)"
        .AddItem "Bachelor of Science in Secondary Education (Emphasis in Social Studies) (Eligible for Institutional
Recommendation)"
        .AddItem "Bachelor of Science in Secondary Education with an Emphasis in Biology (Eligible for Institutional
Recommendation)"
        .AddItem "Bachelor of Science in Secondary Education with an Emphasis in Chemistry (Eligible for Institutional
Recommendation)"
        .AddItem "Bachelor of Science in Secondary Education with an Emphasis in Physical Education (Eligible for
Institutional Recommendation)"
        .AddItem ""
        .AddItem ""
        .AddItem "********************************************Graduate
Degrees*******************************************"
        .AddItem ""
        .AddItem "Master of Arts in Teaching with an Emphasis in Professional Learning Communities (Not Eligible for
Institutional Recommendation)"
        .AddItem "Master of Arts in Teaching with an Emphasis in Teacher Leadership (Not Eligible for Institutional
Recommendation)"
        .AddItem "Master of Education in Curriculum and Instruction: Reading with an Emphasis in Elementary Education
(Not Eligible for Institutional Recommendation)"
        .AddItem "Master of Education in Curriculum and Instruction: Reading with an Emphasis in Secondary Education
(Not Eligible for Institutional Recommendation)"
        .AddItem "Master of Education in Curriculum and Instruction: Technology (Not Eligible for Institutional
Recommendation)"
        .AddItem "Master of Education in Early Childhood Education (Leads to Credential)"
        .AddItem "Master of Education in Early Childhood Education (Not Eligible for Institutional
Recommendation)"
        .AddItem "Master of Education in Educational Administration (Eligible for Institutional Recommendation)"
        .AddItem "Master of Education in Educational Leadership (Not Eligible for Institutional Recommendation)"
        .AddItem "Master of Education in Elementary Education (Eligible for Institutional Recommendation)"
        .AddItem "Master of Education in Elementary Education (Not Eligible for Institutional Recommendation)"
        .AddItem "Master of Education in Elementary Education: Arizona Teaching Intern Certificate Program (Eligible for
Institutional Recommendation)"
        .AddItem "Master of Education in Secondary Education (Eligible for Institutional Recommendation)"
        .AddItem "Master of Education in Secondary Education: Arizona Teaching Intern Certification Program (Eligible
for Institutional Recommendation)"
        .AddItem "Master of Education in Special Education for Certified Special Educators (Not Eligible for
Institutional Recommendation)"
        .AddItem "Master of Education in Special Education: Cross-Categorical (Not Eligible for Institutional
Recommendation)"
        .AddItem "Master of Education in Special Education: Cross-Categorical: Arizona Teaching Intern Certification
Program (Eligible for Institutional Recommendation)"
        .AddItem "Master of Education in Special Education: Cross-Categorical (Eligible for Institutional
Recommendation)"
        .AddItem "Master of Education in Teaching English to Speakers of Other Languages (TESOL) (Not Eligible for
Institutional Recommendation)"
        
    End With
    cboEnrollmentAdvisor.Value = ""
End Sub

Private Sub CommandButton1_Click()

End Sub


Hello,
how to obtain database connectivity between Excel 2007 and Access 2007 so that i can retrieve the values from access database to VBA forms and vice verse.
my Windows version is 2007....
Thanks in Advance

I am using excel 2007 and encoutering problems accessing the sage line 50 templates to enable me to link my sage line 50 data to the templates. Using Windows Vista.

I ahve selected file, new, browsed to local disc, uders, me, App Data, Roaming and Microsoft folder, then templates folder. However, the templates folder is empty. Am I browsing to the wrong folder?

I am using Excel 2007 and I am trying to import a text file that has about 750,000 rows. When I do an import with a text file as its source it only gets to 65,534 rows like it does in Excel 2003. It does this because its in "compatability mode". how do I turn this mode off?? I want the normal 2007...

Thanks!

Wow, what a confusing change Excel 2007 is over its predecessors!!

My main battle is trying to get macros to run after saving to the new
format.

The macros run fine if I open as an xls, but if I save as xlsm and try to
run the macros I get a message stating that the macros may not be available
or may be disabled. I checked, and the macros are still there but I can't
run them.

When I first installed Office 2007 I used to get a message warning about the
macros and giving me options to allow, etc., but that warning never appears
anymore. I suspect after I went into the Trust Centre and set the option to
enable all macros things went south after that. I checked all the security
settings, etc., but I never get a warning about macros. They are just
disabled (unless I leave it as an xls file).

Please help. I don't want to uninstall and reinstall. I did try the repair
option which made no difference.

Rob

All,

I have a Macro that I wrote that I need to be able to run. I am using Excel 2007. This workbook and macro were written in Excel 2007, and I saved the file as a "Macro Enabled Worksheet". The Macro was working fine before and after saving it.

When I opened the worksheet later today and tried to run that Macro, it says,
"Because of your Security settings, Macros have been disabled. To run macros, you need to re-open this workbook, and then choose to enable macros. For information about enabling macros, click Help."

I did click Help, and there was nothing useful there. (If their solution had worked, it would have been useful, but it did not.)

My security settings for Macros are currently "Disable all macros with notification."

It doesn't, however, give me an notification or choice to run the macros or not.

I need this macro to work, and one solution that I read (save the macro to your personal workbook and access that when you need it), I didn't even try because it is not an option. I need to be able to pass the Macro with the workbook to some other users.

Thanks in advance for any help. This is the first major problem I've encountered with Excel 2007, but it is an extremely annoying one.

I am running Excel 2007 and Windows Vista Business. I have enabled all
macros and checked the trust access to the vba project object module.
Despite this I receive the following error message: 'Because of your
security settings, macros have been disabled. To enable macros you need to
reopen this workbook and then enable macros.' I have done this multiple
times. It does not work. I have done multiple searches on Google and at the
Microsoft website. Nothing is showing up related to this particular problem.
Can someone recommend a solution?

Thank you.
--
Randy

I have searched the internet and cannot find a solution to this error:
I created a Excel workbook in Excel 2003 with lots of macros. When I run it on two Excel 2007 machines it works fine when you select to enable the macros. Except for one user on 2007, it gives this error"
"Error 1004. Because of your security settings your macros have been disabled......"
I then go to the Security Settings in the TRUST CENTER and allow the macros, but it still does not work. I cannot get the macros to run or even prompt me to run. I have tried so many different selections in teh Trust Centre.
Anyone have ANY ideas???

I have an Excel workbook that I have been adding data for several years now. It has a sheet for each week and summary sheets each month.

Out of the blue I started getting a security warning enable/disable dialog box each time I open the workbook. There are no macros on this workbook. Tools>macro does not show any macros attached.

I don't want to turn off the warning for sheets that actually contain a macro.

How do I get rid of this dialog?

I have macro security set to "Disable all macros with notification".
I keep opening a file in 2007 and Excel doesn't give me the option to enable macros.
Usually when I close the file and reopen it, I get the dialogue to enable macros, but occasionally it never happens, and I have to go into macro security and set it to "Enable all macros".

Using Excel 2007, I have a macro that I need to run on a scheduled basis. Based on tips I found, to avoid lowering all macro security, I made the macro name "Workbook_Open" in the "ThisWorkbook" object. I saved the workbook into the XLSTART folder.

Again, based on tips, I expected that when I started Excel, the macro would run. It did not.

So, I opened the workbook, and the macro did run. At the end of the macro I save the workbook (to save the update made by the macro running), and close the file (using Workbooks("filename").close).

I set up a scheduled task to open the file, and thus run the macro. This did work, but when the file was closed, an instance of Excel remains/appears. This is not desired, and in fact prevents the schedule task from working at the next scheduled time. I tried adding an "Application.quit" and "Application.exit" at the end of the macro, but that made no difference.

Can I prevent the instance of Excel from remaining after the scheduled task and if not, how can I change the macro/scheduled task to get Excel to close completely?

Here is the code:

Sub
workbook_Open()

My code to execute a web query and update one of the worksheets is here

Workbooks("Workbook Name.xlsm").Save
        
Workbooks("Workbook Name.xlsm").Close

Application.Quit 'does not close Excel
Application.Exit ' does not exit Excel

End Sub
thanks in advance