Protect VBA Project Or Lock Project For Viewing By VBA

Apr 27, 2007

I have tried to record macro to protect VBAProject / lock project for viewing. But can not success by that way.

View 9 Replies


Lock Project From Viewing

Oct 22, 2008

I've done the following steps so far:

Checked the "Lock Project from Viewing"
Applied a password
and clicked Ok

View 3 Replies View Related

Generating List Of Project Parts Based On Project Duration And Time Window

Aug 4, 2014

I have a table of projects with 1) duration in year, 2) time window (number of years of our planning cycle), and 3) start year of the project. I want to generate a list of project parts of all projects where they may take place. This will serve as an input to an optimization program.

So a project of 2-year duration should have 2 parts over any year within the time window. I am including the "impossible" ones for my developer to tag them as "0" when we run it through his code.

View 5 Replies View Related

Consolidate 4 Excel Project Lists (Workbooks) To New Master Project List Using VBA

Sep 5, 2013

My task is to consolidate 4 Excel Project Lists (Workbooks) to a Master Workbook. The Project Lists has a different structure and almost different content. The relevant information is always on Sheet1 but it has completely different ranges. The only constant is the Project Number, which should be used to sort the information. Every Project should be listed only once with all the existing information.

I found a code written by Ron de Bruin which has already some components that I want to have in my VBA but I think there are still a lot of necessary adjustments to do.

Sub MergeSelectedWorkbooks()
Dim SummarySheet As Worksheet
Dim FolderPath As String
Dim SelectedFiles() As Variant
Dim NRow As Long
Dim FileName As String
Dim NFile As Long
Dim WorkBk As Workbook


The Master Project List should has the headers in Row1 and the information listed below. The Macro should automatically places the correct information to the correct column. Some of the information are in 2 or more of the lists but they should be listed only once in the Master List.

Project Number

Project Description


I guess a problem is that the structures of the Lists are quite different so there must be a kind of sorting process.

In the end I want to have an Excel File with the Macro and a Command Button and by clicking the Macro creates a new Workbook with the Master List.

It would be better if there is a variable range instead of a defined. Like the Macro searches the last row and starts at this row and column.

View 4 Replies View Related

Get Excel To Open MS Project File And Then Run Project Macro On It

Jul 30, 2013

I am trying to get excel to open a MS Project file and then run a project macro on it.

What is happen is that when I run my code it works, and then excels VBA window freezes up and the run arrow goes away, and if I try to open project I just get a chiming noise and it won't open.

For now I have to select the MS Project file from a directory, but in the future I would like it to go through the folder and open all of the file in the folder

Sub ImportMSProject()
Dim FileToOpen
Dim mpApp As MSProject.Application
Dim prjmacro As Object
'Identify the File to Open - START
FileToOpen = Application.GetOpenFilename("Microsoft Project Files (*.mpp), *.mpp")
If FileToOpen = False Then
Exit Sub
End If
'Identify the File to Open - END


View 9 Replies View Related

2007 Vba Project Lock

Jul 16, 2007

I'm trying to save an Excel 2007 document with a VBAProject password protected and can't get it to work. I have tried numerous formats (xlsx,xlsm,xlst etc) and when the workbook is opened the the password protection is not enabled! All the settings for macros etc are at their lowest.

View 3 Replies View Related

Lock VBA Project With Code

Jan 19, 2008

I understand that we can protect the VBA coding through check the "Lock project from viewing in the Tools>VBAProject Properties. However I would like to know if this is possible in code?

I have a mainworkbook for users that has the VBA coding protected (it contains passwords to unlock protected sheets / main workbook). In my program, the users will be entering data and then push a button which calls a macro to email a "skinny down version" of the main book to other users. Problem is, these users that receive the email will be able to get into the VBA code and see what the password is on the sheets. (even if the new workbook/worksheets are password protected) Is there any way when I save the new book to add this protection to the VBA code?

View 7 Replies View Related

Protect VBE Project Using Code

Mar 31, 2009

Is there a way to protect a VBE project using a macro instead of going to the properties and manually typing in a password? I'm using a macro that emails just one worksheet in my workbook (creates a new temp file, emails, and deletes it) but when the new file gets to the recipient the VBE project is unlocked.

I found a way to protect the worksheet before saving the temp file, so the worksheet is protected as it should be, but the project explorer window is completely open. Then anybody can see the passwords I'm using to protect the sheet in the first place. So I need to somehow re-protect the project before it saves and emails.

View 4 Replies View Related

Tally Report Of X: Count On Column B (project $) Depending On The Criteria On Column A (project Description)

Aug 28, 2007

I need to write a couple of functions. Firstly I want to do a count on column B (project $) depending on the criteria on column A (project description). For example a total count of all values in col B if project description is "P" or "A". [I can do sumif functions but this is a countif and I cannot get this right].

View 4 Replies View Related

Vba For Project

Jun 30, 2007

I am looking for a forum or where I can find advice on using VBA with MS Project.

View 2 Replies View Related

Protect Sheet From Viewing?

Jan 18, 2012

I have a workbook with several worksheets. I need to prevent users from viewing worksheet mgrview unless they have a password for it.

View 1 Replies View Related

VB Project Protection

Feb 12, 2009

I'm trying to protect my project so that others can't unhide a sheet I have tagged as veryhidden within VB.

I followed these steps:
1. Select project in the projects window
2. choose Tools
3. Project Properties
4. Protection tab
5. checked lock porject for viewing
6. entered passwords twice
7. clicked ok and saved

On another file this has worked perfectly as I wanted it to.

However on another very large file with multiple VB projects it is not "taking" on the project I need it to.

I can open the file, the VB project and change the setting on any sheet I need to without entering a password.

View 14 Replies View Related

Add Project To 'database'

Mar 9, 2009

Add Project to 'database' I recorded my marco.

View 3 Replies View Related

Project Not Closing In VBE

May 7, 2008

I have a macro in a workbook (WB1) that opens another workbook (WB2). After performing several other macros through user invocation with buttons, I close WB2 with the following statement:

ActiveWorkbook.Close (False)

While the WB2 workbook closes okay, the WB2 project is still open in the VB editor. Does anybody know why this code isn't closing the project in the VBE?

The WB1 process can occur multiple times while Excel is open and each time a separate occurrence of the WB2 project is left open in VBE.

View 9 Replies View Related

Start And Name A New Project Using VBA

Nov 28, 2007

how to start and name a new project in Excel VBA. Will someone explain how to?

View 3 Replies View Related

Password Protect Sheets From Viewing

Sep 12, 2006

I have a excel file with around 8 sheets in it and this file puted in the network to be shared with 8 persons So i need to make an individual password for each one to enter to his specific sheet and have full authorization to make anything in it and this done using userform where each one when open the file in the network , a user form open in first stage to select his name and put his own password with the ability to let each one to make his own password or change it from the userform

this file is shared so it may more one user open it and it may be there an save funtion at same time ( same time & same activities )

View 9 Replies View Related

Password Protect Worksheets From Viewing

Jan 3, 2007

Here is what I try to achieve:

- I have a "Menu" worksheet with basic Hyperlink to Sheet1, Sheet2 etc.

- When I click on a link (or on the tab), I want a prompt asking for a password (different for each tab). I do not anyone who doesn't have the correct password to see the content of the worksheet.

(I don't know VBA and I couldn't modify the code to fit my needs)

Here is the code posted

Dim sLast As ObjectPrivate Sub Workbook_Open() 'Ensure Sheet1 is not the active sheet upon opening. If Sheet1. Name = ActiveSheet.Name Then Sheet2.SelectEnd

View 9 Replies View Related

Protect Workbook From Editing / Viewing

Feb 14, 2008

I have placed a workbook on a network drive. This workbook contains sensitive information and I would like to protect it to a "feasible" degree. I have written the following code

Private Sub Workbook_Open()
Dim userid As String, valid_userid As String
Dim i As Integer
valid_userid = "MISI01/"
userid = GetUserName()
userid = UCase(userid) & "/"
i = InStr(1, userid, valid_userid)
If i = 0 Then
MsgBox ("You are not authorised to use this workbook")
ActiveWorkbook.Close False
Exit Sub
End If
'create menu when workbook opens
Call Module1.CreateMenu("")
Call Modul1.check_filedate("")
' This will disable the user from moving, renaming etc the sheets
ActiveWorkbook.Protect Structure:=True, Windows:=False
End Sub

As can be seen from the above code, I check if the current userid is one of those that are valid to open the workbook. If not the idea is to tell them and close the workbook immediately (this bit isn't tested yet). This code is not supposed to be hacker proof, but to prohibit the casual user from reviewing the the data.

View 3 Replies View Related

Project Supplies Tracker

Apr 11, 2014

Shee1 , sheet2 raw data from system extract.

I need the supplies of each code to fall into boxes sup1 sup2 and so.

While I also need when they were supplied created below the qty supplies table.

View 14 Replies View Related

Make A Stand-alone Of Project?

Mar 30, 2009

I'm not close to done yet, but when it's complete I want to distribute the project to people that might not have Excel 2003 or 2007. So, can I package an Excel file with UserForms into a stand-alone tool?

View 2 Replies View Related

Working On A Real Project

Oct 5, 2009

Is there a place on the net where I can work on, or take part of real Excel
project ( for training purpose ). If not, do you think that is possible to make such a place were people can learn and practice excel working on simulation of a real Excel projects??????

View 4 Replies View Related

Employee's Project Report

Jan 26, 2010

I have created a spreadsheet in Excel where it gives me a report of how many hours my employees do per week and it seperate them in different categories.

What I would like to do is find a way to match the cell's description with the amount of total hours that were spend on certain project.

So here is the scenario.

In my department there 6 employees that are assigned to work on certain projects in daily basis. These projects are called CRs and to identify them I've added a number after them.
So we will have CR0001, CR0002, ect. These are unique projects.More that one employee that could woork at the same project as well on other sections but I am only interested on the projects.

To help you understand what I am trying to do I will give you an example.

John is working on project CR0005, CR0006, CR0001. He has been working on them three projects for the last week.

Here is the summary of the hours:

- 5 hours on CR0005
- 10 hours on CR0006
- 5 hours on CR0001

This information is inputed in Excel spreadsheet Week 1 .....

View 12 Replies View Related

Project For Selecting Top 10 Items And Then Looking Up The Name

Sep 5, 2013

I have attached a sheet with a sample of how my spreadsheet will look. This might involve a number of steps. I have actuals, forecast, and prior year information (for rolling months) for a number of line items. To the right, I calculate a variance (in total and %). What I want to do is create a list to the right (not sure how to format it) that populates the 10 items from the left with the most variance (units, not %). I would like it to populate the line item from the right as well as the number of units for the variance (columns F and H). Lastly, and I'm not sure if this possible, I might want to just select the items that are greyed out. That is, I would want the line items with the most variance but just from the greyed out lines. If this is not possible without a macro, I don't want to do it.

View 2 Replies View Related

Can't Find Project Or Library ...

Nov 19, 2008

is if I F8 through the code it works fine. But when I run the code through the button on the spread sheet. It stops at the Format comand. And says "Can't Find Project or Library." Has anyone ran into this issue or know how to solve it.....

View 2 Replies View Related

Reset Project On Open

Mar 24, 2009

I'm a noob to programming in XL, and am teaching myself through a project for manipulating vectors. One thing that has me stumped is that when I open the file in which I'm working, I get a "This action will reset your project..." message.

View 7 Replies View Related

Can't Find Project Or Library

Feb 13, 2010

I am getting a complie error that I did not get when the code was written. Earlier versions of the same workbook still work fine without error. I hope thie workbook is not corrupted.

The error happens with the None command in this code for a button in a user form.

View 6 Replies View Related

Excel Export To MS Project?

Oct 21, 2011

If i have a table full on excel data, date, names etc, and I have a userform where someone has filled all that in. On that particular userform I was wondering if their's a way I can get it to write each column over to a sample MS project document.

To save me having to manually change it over?

so on clicking a button, what ever's in sheet1 say it writes out out to specific ms project strips, e.g. start date(excel) written out to data(project)

View 8 Replies View Related

How Can I Step Through Project Code

Dec 7, 2006

I am looking at the code in a MODULE, I can use "F8" to step through it.

But if I have no module just the main project code I cannot find a way to step through it.

View 9 Replies View Related

Find The Project Or Library

Dec 15, 2002

I have written a program in VBA. When I run this program on other computer VB showes "Can't find project or library" error and all of the the common function like "Str" and "Left" and... are not known by BVA. I think I know the reason I have a missing references in my program.

first , can I check it before runing the program by a macro?
second, How can I solve the error?

View 9 Replies View Related

Multiple VBA Project Explorer

Jul 7, 2009

As of a few weeks ago the project explorer in VBA on my laptop has started retaining the information on all files/projects opened during the current Excel session so closing a file in Excel does not remove it from the VBA editor.

Furthermore if a file has been opened several times during an Excel session, it appears several times in the project explorer and editing the “dormant” versions does not impact the currently open copy of the file so the whole thing can get quite confusing and result in changes to not being saved.

View 9 Replies View Related

Copyrights 2005-15, All rights reserved