Lock Project From Viewing
Oct 22, 2008I've done the following steps so far:
Tools
VBAFormatProperties
Checked the "Lock Project from Viewing"
Applied a password
and clicked Ok
ADVERTISEMENT
Protect VBA Project Or Lock Project For Viewing By VBA
Apr 27, 2007I have tried to record macro to protect VBAProject / lock project for viewing. But can not success by that way.
View 9 Replies View Related2007 Vba Project Lock
Jul 16, 2007I'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 RelatedLock VBA Project With Code
Jan 19, 2008I 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?
Generating List Of Project Parts Based On Project Duration And Time Window
Aug 4, 2014I 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.
Consolidate 4 Excel Project Lists (Workbooks) To New Master Project List Using VBA
Sep 5, 2013My 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.
Code:
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
[code]....
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
...
1111E.000000001
[code]....
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.
Get Excel To Open MS Project File And Then Run Project Macro On It
Jul 30, 2013I 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
EXCEL CODE
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
[code].....
Tally Report Of X: Count On Column B (project $) Depending On The Criteria On Column A (project Description)
Aug 28, 2007I 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 RelatedUniversal Viewing Preferences....
Sep 24, 2009Is there a way so that on his computer he can tell Excel that each sheet to be viewed should have a standard/automatic view set to 100% or another percentage?
View 3 Replies View RelatedProtect Sheet From Viewing?
Jan 18, 2012I 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 RelatedRestricting Viewing Of Particular Cells
Oct 23, 2007I do not want to send each rep a file only with their own sales figures as this will be very time consuming. If I could send one file to all representatives but restrict their view to their own figures only, this would make life much easier. If necessary I can set up passwords for them.
Viewing A .csv File In Excel
Feb 17, 2010is it possible that when i open a .csv file in excel i can make it only display some of the columns? The program i am using exports more info then i need and it gets very tiresome to delete each column manually.
View 9 Replies View RelatedViewing A Hidden File
Jan 23, 2007I am not sure why but when I opened a particular file, the file hides somewhere in Excel. I am unable to view the file but when I try to open the same file again, Excel prompts that the file is already open but I can't see the file.This is an important file at work and I am not sure how to actually get to view the file. I tried copy and pasting the file in another location and then trying to open in Excel. However, the same thing happened.There is no error message.The file is opened but I am unable to view, as it seems to hide from view.Is there a solution?
View 7 Replies View RelatedExcel Crashing When Viewing VBA Code
Dec 27, 2012I have a semi-large macro which I have been creating on and off for a few months now. The file will fundementally be used by people with little knowledge of Excel, hence I force the user down certain alleyways depending on what they have previously done with the aid of veryhidden sheets and such like.
Upon opening the file, some code is ran to hide all of the sheets in the file apart from the home page. This is a pain when I am still working on the code though, so a portion of it is commented out. When I uncomment the "on error.. - next sheetIn" so that the file runs as it would be used, the code itself works perfectly and hides all of the sheets apart from the home page. Unfortunately, I can't then view the VBA code as it instantly crashes Excel (and any other Excel file I currently have open). This happens whether I click the Visual Basic button in the Excel ribbon, whether I try and access it through the design mode on a control, pressing Alt+F11 or even opening up another spreadsheet containing code and attempting to click on the broken macro after viewing the VBA code for the working spreadsheet.
VB:
Sub workbook_open()
'stop screen flickering whilst running the code
Application.ScreenUpdating = False
[Code]....
The only way currently to get back into the code is to open the spreadsheet up with macros disabled and recomment the code, but obviously this loses the function of the code.
Viewing Worksheets In Full Screen?
Oct 30, 2011I have large workbook with various sheets. In my first worksheet I have some command buttons that call each sheet as needed. However, I would like each sheet to be displayed either as a web page or in a way that the user does not see all of the menus, bars and so on.
View 1 Replies View RelatedViewing XLSM On Android Tablet?
Aug 9, 2012I'm trying to open a .xlsm on an Android tablet with only OfficeSuite installed. Initially, that didn't work. After installing a DocumentsToGo application, it shows me my spreadsheet, but none of the .jpg's that are visible in the original file. I copied all .jpg's to the tablet; both the .xlsm and the folder with the pictures are in the same parent folder, to simulate the original folder structure in Windows. Still the pictures will not show.
View 1 Replies View RelatedViewing And Printing Selected Worksheets - VBA
Sep 3, 2009I have a workbook containing a number of spreadsheets. Some of the spreadsheets are user inputs. The results of the user inputs drive a number of final reports. The final reports (i.e. spreadsheets) are hidden from the user (I don't want the user to be overwhelmed with so many tabs when they open the excel spreadsheet).
I created on the main input tab spreadsheet the following:
1. Check boxes - so that user can select after making his/her inputs the reports that he/she wants to view or print.
Say there are 4 reports (call them Sheet1, Sheet2, Sheet3, Sheet4 - therefore, 4 check boxes. Through the Format Control, the checkboxes have cell links that yield TRUE (if selected) or FALSE if not selected - linked to cells A1, A2, A3, A4 respectively.
2. Option buttons - one for view and another one for print. Through the Format Control, the View and Print option buttons have cell links to cell A5 yielding 1 for View and 2 for Print.
3. Command button - that will clear the check boxes
Issue
I would like to know if there is a way to code in VBA to:
1. Unhide the spreadsheets corresponding to the check boxes if selected;
2. Print the spreadsheets corresponding to the check boxes if selected for printing; and
3. Clear the checked boxes to unchecked if the Command button is clicked.
I'm struggling with coding to perform the above tasks.
Password Protect Sheets From Viewing
Sep 12, 2006I 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 )
Stop Formula Viewing Without Protection
Dec 13, 2006I am looking for the code to keep certain cells from being rested on, they can be clicked on but in order for you to view the formula in the cell you have to hold down the mouse button otherwise it will move you over to the cell next to it. I was using another worksheet a while ago and was trying to view the formulas but when I clicked on the cells holding them it would move me to the next cell, the only way I could view them was to hold the mouse button down as soon as I would release it it would be gone! I do not want to protect the sheet, if there is another way to hide formulas I am open to all ideas!
View 4 Replies View RelatedPassword Protect Worksheets From Viewing
Jan 3, 2007Here 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
Protect Workbook From Editing / Viewing
Feb 14, 2008I 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.
Macro To Popup Image In Excel (Just For Viewing)
Sep 15, 2014I am in need of a macro. I have a column with Image No.s around 900. What i want is as soon as i click on a image No. in a cell, the image has to pop up in excel itself(Not in particular cell). The images are in separate folder in the same directory. I have to view the images only(not inserting). Just Pop up the image and as soon as i click on next image no. macro has to remove the old image and in that place new image has to pop up.
View 1 Replies View RelatedScroll Window Viewing Another Page Or List
Mar 3, 2009I'm trying to display in a condensed fashion (in a list box, that way users can just scroll that box instead of the entire sheet), but it keeps giving me error messages saying it doesn't have enough memory to open. Granted, it is a lot of information (a full page's worth at least), but I moved some values around and had it load a different list of only 4 values and it still gave that message- so I can only assume I'm only using it wrong.
View 3 Replies View RelatedCondition Formatting - Viewing CF Formula At Each Cell
Jan 6, 2010I'm referring to a post I tried to solve:http://www.excelforum.com/excel-gene...ml#post2227328
NO need to read. Try the attachement instead.
Steps done:
Select Column D
CF function =D1<A1
Select Column A
CF function =A1<D1
If I select cell D3 and look at the CF then I see:
CF: =D1<A1
where I would like to see
CF: =D3<A3
I remember this was the case in <=XL 2003? (now using 2010 beta)
Creating A Workbook Menu For Viewing/printing
Feb 28, 2008i want to create a menu in the worksheet named "Main Menu" that lists all the other worksheets within the workbook with the option to select the required worksheet and view or print it.
View 7 Replies View RelatedPassword Protect Viewing Of Individual Worksheets?
Dec 1, 2009I would like to adjust the code found in the attached thread so that i can allow one person access to more than 1 sheet
Password Protect Viewing of Individual Worksheets?
Password Protect Viewing Of Individual Worksheets
Nov 6, 2009I have a file w/ individuals monthly sales information (per worksheet) that needs to be distributed in one mass email to the entire sales force. I want everyone to have access to the "Summary" tab, but individuals should only have access to their own "Details" tab. I know there has to be a way to accomplish via VBA. However, I'm not proficient in writing code.
View 9 Replies View RelatedFilter Data For Viewing Using Multiple Conditions
Jun 16, 2009I am far from advanced in excel, but I have been tasked with creating a macro which includes filtering.
1) I have a workbook called Workbook1
2) I need to copy Sheet 3 from Workbook1 cells A1-J5000 into a new workbook called Master.
3) Column D is labelled Status and the two statuses are Enabled and Disabled.
4) I need to copy anything labelled Enabled to a new worksheet in the workbook already created called Enabled and then the same for Disabled. I then need to put it into date order which is column F labelled Date.
I have been trying to work on this all morning, but have found that Excel doesn't like Macros with filters and I don't know the first thing about VBA
Viewing A Zipped File That Contains More Than 65536 Records
Oct 6, 2006I have been sent a file that has been zipped. I am trying to open it so that I can see all the data. So I have extracted it and opened it in EXCEL my problem is that I get an error message 'File not loaded Completely' and I am only able to view 65 536 (the max records) in my EXCEL doc but I need to see the rest of the file. Does anyone know how I can do this?
View 6 Replies View RelatedTODAY() Function And Viewing Or Printing Original Date
Mar 29, 2009I have a seemingly simple dilemna and wonder if there is a solution... I am not a PRO user, but can get by with my limited knowledge of excel.
My issue:
I create invoices for my business and in the invoice I use the "TODAY()" function to automatically insert the current day when I created the invoice.
Now when I need to go back and look at the old invoice or print it again it shows the CURRENT date, not the original date when it was saved. Is there a way to view and/or print out a file while keeping the original date intact or is there a better way to format a date to avoid this happening in the future.
I have since eliminated the function and just type in the date to avoid this but I have about 100 invoices that are saved that I may need to view their "original" dates on.