Windows 10: EXCEL What does ERROR 13 SOURCE VBAProject mean.

Windows 10 all updates applied.Excel is version 2211 build 15EXE831.20208 Click-to-Run The error is raised in the workbook Open code. Debug.Print "In Open ERROR " & Err.Number & " SOURCE " & Err.Source In Open ERROR 13 SOURCE VBAProject TIA for your help. SweetTasha

:)

 

Help needed with Excel Attendance Sheet

You use the Data tab, Data validation facility to do this.

If you want a coherent explanation then look in Excel Help. Here's the relevant extract from Excel 2007 Help. Excel 2007 Help - Data Validation.pdf

My example:
- I have written them in what seems to me to be the order of easiest explanation.
- You'd actually set them up in the reverse order - step 3, step 2, step 1.

1 The result - my dropdown list. I select the cell then click on the dropdown arrow that appears next to it.




2 To set this up, select the whole column [or individual cells] where you want the dropdown to appear then click on the Data tab then the Data validation control. You need to
- select In-cell dropdown
- set the Allow entry to List
- in Source, enter the worksheet name & cell range where you have written the allowable entries - you will generally want to use absolute cell references such as those shown [$ in a cell address means absolute and will not vary as you copy the formula all the way down your column - look this up if you are not familiar with it because it needs a bit of getting used to].




3 Write out the list of allowable entries that will appear in your dropdown list.




Job done.

Denis

 

Excel isn't opening properly

Hello BradBoner

Does the error pop up as soon as you click on the Excel program to open or once the Excel is opened?

Try the steps below and check if it helps:

Step 1:

Try to open Excel in safe mode and check if it opens:

· Hold Windows key + R.

· Copy and paste, or type the following command in the Open box, and then press Enter:

Excel /safe

Note: There is space between Excel and/

If the issue does not occur in Excel safe, then try to disable add-ins associated with Excel 2013 and check the result.

· Click on File menu, Options and then Add-ins.

· Click on Go button besides Manage: Com-in Add.

· Check if there are add-ins listed, clear the checkbox to disable them.

Step 2:

If the above step fails, try the step below:

Right click on Excel (.exe) > Properties > Compatibility > uncheck all the boxes, click Ok and check if it helps.

To access Excel (.exe), open the following location:

C:\Program Files\Microsoft Office\Office15\Excel.exe

Or

C:\Program Files\Microsoft Office 15\Root\Office15\Excel.exe

Try to open Excel and check if it opens.

Source:https://answers.microsoft.com/en-us/office/foru...

Hope this information can help you

Adis R. Asesora Independient

 

excell

Hi Amaedodgers

Open Excel from its Shortcut, do you get any errors?

Do you get this error with all Excel files?

If you cannot open Excel on its own or you are getting an error on all Excel files, follow these steps to perform a full repair of your Office installation . . .

Open Control Panel - Programs and Features

Click Microsoft Office in the list of installed applications

At the top, click 'Change'

On the resulting dialog, click 'Repair' - choose the Online Repair, it is a comprehensive fix

That should fix any issues with your Office Installation . . .