Changes Aren't Saved While VBE Is Protected

Sep 2, 2007

I have a WorkBook of 13 sheets

it has 2 Modules:

one unraveling protection from cells protected and restore it to all Sheets in a single step

And the second controls printing process to make it only for rows that conaining date in the predetermined columns

that latter is to break the protection, execute printing and re protection again without user intervention

The strange thing is : after protecting these modules from being viewd by users as it contains THE PASSWORDS .....

View 9 Replies


ADVERTISEMENT

Rows That Should Be Selected Aren't

Nov 18, 2009

What I have just tried is click "Reset" in the macro menu and resaved the macro and the workbook, and the proper max/min lines seem to be working. However, I still feel a little unstable about it and will watch it closely.

(My next questions is how to "freeze pane" a row of headings on the results page and post the results onto row 2 and downward *without* deleted row 1)
Hello,

Here is my hurdle.
Could someone please look at the code below and see if there is a hint why all rows from the top all the way down (from R5 to R604) are outlined, when the code should successfully be stating already that if a value in the S column (to the right) is the maximum, then only outline the rows that across the R rows (up and down) that are the MIN? Then, those red-outlined rows should successfully display on the Results page.

It worked before, but I do not know now why all of the rows on the Details page are now selected.

Is there some indicator in the code that says outline everything?

Issue 2:
When I try to run the macro from a button I created, a pop up message says that the file is already open. If I take that literally, it is indeed true because I want the file open. Apparently Excel thinks I have 2 files open with the same title. It wants me to either close one of them or rename them, according to the message. But there isn't another file open according to my searching. What does that message really hint for me to do?

View 12 Replies View Related

Why Aren't These 2 Cells Equal

Aug 21, 2008

I have a date on one sheet, and what I thought was the same exact date on another sheet. I want to vlookup off the date, however the values aren't the same. i.e. when I check to see if they = I get a false. They're both formated the same, custom date m/d/yyyy h:mm, and when I ran the check to see if one was text (t=(A1)) I get confirmation that they are both non-text!

View 9 Replies View Related

SUM If X Cells Aren't Blank

Aug 21, 2007

How should I use the If formula in K3 if I want to sum (A3+D3+H3) only if at least one of the cells is not blank. If all of the three cells are blank, I need K3 to stay blank.

I came with the following that worked with only A3+D3 but when trying to include a third cell (h3) I get a "value" result.

=IF(ISBLANK(A3),IF(ISBLANK(D3),"",A3+D3),A3+D3)

View 9 Replies View Related

Cells That Appear To Be Equal, Aren't

Mar 1, 2008

I have 2 text cells (A1, B1) that appear to be the same, however, when I typed the formula "=if(A1=B1,"Yes","No)" in cell C1 the result is NO! (see attachment)

View 4 Replies View Related

Cells Aren't Properly Aligned

Aug 5, 2008

I have some columns of data that won't get perfectly aligned. The numbers in all the cells are right aligned but the numbers in some of the cells are a few pixels to the left compared to some other cells that appear to be properly right aligned.

I have attached a screenshot if my explanation isn't clear.

View 3 Replies View Related

Macros Aren't Printing As Instructed

Jul 19, 2006

Here's some code, written by assorted forum members (thanks again!). It is attached to a button and intended to print a report that is determined by the contents of cell Y4.

Sub PrintSingle()

Application. ScreenUpdating = False
ActiveSheet.DisplayAutomaticPageBreaks = False
With ActiveSheet.PageSetup
.PrintArea = "$Y$4:$AG$21"
.Zoom = 95
.Orientation = xlLandscape
End With
Application.ScreenUpdating = True
ActiveWindow.SelectedSheets.PrintOut Copies:=1

End Sub

I've been using/testing this for a couple of weeks now and it has appeared to work exactly as intended. Today, however, as I've attached it to additional sheets, and begun testing them, I noticed that it isn't actually following the code in determining page setup options. The options selected in each individual sheet's setup box are overriding those specified in the code.

Apparently, the only reason it's been printing appropriately for the last couple weeks is because the options selected in the setup box for that particular page are the same as those specified in the macro.

View 3 Replies View Related

Copy And Paste Area Aren't Same Size

Jun 26, 2014

I'm trying to paste the column that my code found into the blank cell C18, which may change in the future, but I got an error that I need to select the cell to paste the column to - I'm not getting the code right. Here's what I've tried:

For Each Cell In Sheets("Total Sell Dollars").Range("1:1")
If Cell.Value Like "2014*" Then
BlankRow = Sheets("Total Sell Dollars").Range("C" & Rows.Count).End(xlUp)

Cell.EntireColumn.Copy Sheets("Total Sell Dollars").Cells(BlankRow + 1).Select.Paste
Sheets("Total Sell Dollars").Select
End If
Next

When I run this:
Cell.EntireColumn.Copy Sheets("Total Sell Dollars").Cells(BlankRow + 1).Select.Paste
line gets highlighted and it says:
"Run Time error '424': Object Required"

This is the code that I tried when I got the paste error:
Cell.EntireColumn.Copy Sheets("Total Sell Dollars").Cells(BlankRow + 1)

and the error was: Run-time error '1004'
We can't paste because the Copy area and paste area aren't the same size.

Try one of the following:
Click one cell, then paste.
Select a rectangle that's the same size, then paste.

Once I paste the column that excel found, I want to go to the next column and paste the found column into the cell C19 - which may change in the future and so on until all the found columns with 2014 in them are pasted.

View 9 Replies View Related

Dropdown Down Menus Aren't Sorting With Their Cells

Oct 21, 2007

when I sort data columns that contain drop-down menus. My spreadsheet has several columns: "Patient name", "Room #", and "Phone #". Each cell within the "Phone #" column should have a drop-down validation list containing two possible entries: the room's designated telephone number, or NONE. Whenever I add a new patient to a room, these three columns need to be sorted alphabetically by patient name. But when I sort all three lists simultaneously, it looks great- but then I realize that the drop-down lists associated with each "Phone #" cell haven't sorted! They stay in their original location and don't sort with their cell. So the designated telephone numbers for each room are all screwed up.

View 9 Replies View Related

Warning Page If Macros Aren't Enabled

Jun 10, 2008

I'm making a little calculator thing for some of my colleagues, and I've created a warning sheet at the front in case their macro security is set to high or they disable macros.

The thing is, when the workbook is opened with macros enabled, and when it's closed, this warning sheet flashes briefly. Is there any way to avoid this?

My code is:

Private Sub Workbook_Open()
Worksheets("Form").Visible = True
Worksheets("Form").Activate
Worksheets("Enable macros").Visible = False
UserForm1.Show
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.ScreenUpdating = False
Worksheets("Enable Macros").Visible = True
Worksheets("Form").Visible = False
Me.Save
Application.ScreenUpdating = True
End Sub

View 9 Replies View Related

Link Data In Worksheets - Add / Deduct Formulas As Criteria Are / Aren't Met?

Dec 31, 2012

What can I do to link my worksheets together? I need the months to link from january to december.

I'm trying to come up with a system to maintain attendance of employees. How do I come up with a rolling system to add and deduct the points as their attendance changes? The goal of each employee is to have the least amount of points as possible, because he/she will be penalized once they receive a certain amount of points.

Let's say that Jane was hired in October. She has accumulated 10 points by December from tardies, call-ins, etc. By the end of January, she has perfect attendance; she is awarded half a point to be taken off toward her 10, giving her 9.5. In February, there is a day she does not show up, so now her total goes up to 12.5 (3 pointed added because of NCNS-no show no call). In March and April, she has perfect attendance, so now her total is 11.5. (half a point allowed for each month with perfect attendance)

By rolling, I mean a formula that will calculate continuously over month after month and have the points roll over month to month.

View 9 Replies View Related

Count Of Dates Less Than Current & Corresponding Cells Aren't Blank/Empty

Apr 19, 2008

I have a formula '= COUNTIF(A1:A5,"<"&TODAY())' that counts the number of expired dates in one column. I want to include a second condition to this formula that will check if another column of dates are blank then they should not be counted. So if for example a1:a2 have expired dates, and b1:b2 have both got dates then they should be included in the count.

View 9 Replies View Related

Imported Data Creates Blank Cells That Aren't Really Blank

Feb 21, 2006

Here's what I'm attempting to do: For each column, X,Y, Z, I am attempting
to count nonblanks. However, the data was imported from Access and Oracle,
and Excel treats what appear to be blank cells as nonblanks. I've tested
this theory by highlighting a couple of "blank" cells and deleting them, and
my count changes. So, can I get Excel to put a value into my "blank" cells,
so then I could filter it out, or create a formula that would only count
dates in my columns (which is what I'm after).

This is what I'm looking at:

A B C
1 2/4/2006 2/6/2006 ("blank")
2 ("blank") 12/13/2005 1/7/2006
3 2/20/2006 1/15/2006 ("blank")

In each column if I use a COUNTA I'll get a total of 3, instead of 2 for A,
3 for B and 1 for C.

View 14 Replies View Related

Excel 2007 :: How To Adjust Protected View Settings But Protected View Tab Is Missing From Trust Centre Settings

Dec 12, 2013

Excel 2007 - need to adjust protected view settings but the protected view tab is missing from my Trust Centre settings - have the following tabs - trusted publisher / location, add-ins, activeX, macro, message bar, external content and privacy options. Document is a revenue authority download and without being able to adjust the protected view settings, can't input data.

View 3 Replies View Related

Changes Could Not Be Saved

Apr 30, 2006

I am getting the following error message while trying to save an excel file into server location.

Your changes could not be saved to [filename], but were saved to a temporary document named [number]. Close the existing document, then open the temporary document and save it under a new name.

I am using:
OS: Windows XP Professional with Service Pack 2.
Office 2000
Server: Windows 2003 with Service Pack 1.

View 4 Replies View Related

Load Saved Csv In The New Sheet?

Aug 30, 2013

I created the csv file from excel sheet. Now I have created a copy of that excel sheet in a new sheet, and I am trying to load that saved csv in the new sheet. But when I do that I see some cells formatting mismatch (can be seen in attached picture) though I clicked on preserve cell formatting at the time of import.

View 2 Replies View Related

Saved Files Read Only.?

Jan 8, 2009

I took two weeks perfecting an Excel file and was writing them to disc just now to transport and use on other machines. I opened the file to add instructions and the files are now read only? Propteries show read only on the written files but not on the originals???

View 4 Replies View Related

VBA To Locate Different Worksheet To Last Saved?

Jan 28, 2014

I have the below formula that pastes data into the worksheet entered in the " " it works great but only when the workbook was last saved on that sheet, how can it locate that worksheet sheet even if the the workbook was last saved and another worksheet. if the workbook was saved on a different sheet name the vba doesn't finish

[Code].....

View 4 Replies View Related

Lock Saved Worksheet

May 28, 2009

I have code written to auto save the active worksheet when a button on my user form is pressed. What I would like to know is if there is a way to lock the worksheet when the button that triggers the save event is pressed behind the scenes so the end user has a more difficult time editing the sheet. I know they can just resave the document and the protection will be gone, but for minimizing user manipulation.

View 2 Replies View Related

Non-Changed Worksheet Asking To Be Saved

Jun 23, 2009

I chose to place this in programming, as all the functions for this workbook are either macros or Internet Links. Nothing is ever changed on the worksheet.

I have a workbook that is fully protected with passwords both for the workbook and the worksheet. When I set up the protection, no check boxes are checked.

I have macros and internet links on the worksheet that can be selected, but none of them affect the worksheet.

As a matter of fact, I can open the workbook and close it with only "Application.Quit" in a macro and a message box comes up asking if I want to save the changes or not. If I close it with the upper right corner RED X, it still asks the question.

I have no "On Open Macros" or Links of any kind.

I have other workbooks that this does not happen on.

View 10 Replies View Related

Execute When Workbook Saved

Oct 15, 2009

I would like to execute a sub when the workbook is saved, what is the procedure for this.

View 3 Replies View Related

File.Saved Changing

Nov 30, 2009

I have a file that keeps setting it's "Saved" property to False when I change something in another file. I cannot find any external links in the file.
The file used to be "Personal.xls", but I renamed it.

View 4 Replies View Related

Date Format Is Not Saved In CSV

May 5, 2014

I have an excel file in which the date format for a column was in the following format -: 3/14/01 Since I wanted the column to display in 'mm/dd/yyyy' format, I changed the type to -: 03/14/01 and the sheet was saved. I then for a specific purpose converted the xls file to csv and noticed that the date formatting I did is not getting saved. That is, every time I open the csv the date format changes back to 3/14/01.

how to retain the date format in excel? I need to use the date format in mm/dd/yyyy only for the application I'm using.

View 2 Replies View Related

Last Date Saved Code

Nov 29, 2006

does anyone have a simnple code that when entered in a cell only returns the last date the file was saved? better yet, could it somehow be specific based on a modification to a specific worksheet modified?

example: i have 8 worksheets. how can i show when one worksheet is updated, say November 27th 2006, and another worksheet on November 28th 2006?

View 9 Replies View Related

Last Date Saved Formula

Dec 20, 2006

Is there a formula that will get the date & time the workbook was last saved? I am using an earlier posted macro now but would like for the information to be visible constantly in a certain cell. Possible?
Macro used:
Sub WhenSaved()
MsgBox "This file was last saved on " & Format(ThisWorkbook.BuiltinDocumentProperties("Last Save Time"), "mmmm d, yyyy") & ".", 64, "Date of most recent save:"
End Sub

View 9 Replies View Related

VBA Macro To Tell Who Last Saved A File

Oct 10, 2002

Macro (saved on the workbook not in the Personal macro file) which should give the following info (lets say on sheet 1, starting A1, A2) who last saved that file and the date.

View 9 Replies View Related

How To Get Last Saved Data Into Sheet

Aug 30, 2007

I have an excel sheet which is shared, i need to get the date and time when the sheet is last saved in one Particular cell.

Example: In A1 = 16/082007 09.00am (in whatever format)

View 9 Replies View Related

File Cannot Be Saved In This Format

Jun 16, 2008

I have a file with code attached and when I try to save it I am told that the file cannot be saved in this format and that I must unprotect the code before saving.

I have no OnEvent macros in the code.

Does anyone have a solution for this problem. The code must be protected, non-protection is not an option.

View 9 Replies View Related

Document Not Saved 1004

May 15, 2009

I have an xls file that has many sheets in.

One of the sheets is a sumamry sheet that get's dulpicated, values pasted, then (the single sheet) exported to a new file. Upon trying to save this file, I keep getting the run time 1004 error message and that my document cannot be saved.

I've struggled for days trying to find out the source to no avail.

What is more frustrating is that when I try to save it (after exiting the macro), it seems to work ok.

I do get the compatability error message (which I don't get on the 'original/parent' workbook) there is a not about format errors, though I'm not sure that's the source of the problem.

View 9 Replies View Related

Time Passed Since Last Saved

Mar 8, 2007

Private Sub Workbook_Activate()
Dim user As String
If Worksheets("Setup"). Range("D6").Value = "" Then
user$ = InputBox("Hello. Please enter your name to inialize the program", "Enter Name")
Worksheets("Setup").Range("D6").Value = user
MsgBox ("Welcome " & user & ". Press 'OK' to continue on to the Main Menu.")
Else
user$ = Worksheets("Setup").Range("D6").Value
MsgBox ("Welcome back " & user & ". Press 'OK' to continue on to the Main Menu.")
End If
Exit Sub

but i would like to expand the "welcome back" msgbox to also display "the last time you were was was (eg: 2 days/3 hrs/14 min) ago" - which i presume would be calculated from the last save.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved